Dear guest !

Welcome to Team Developer Community Forum. A place created by the community, for the community !

This is a resource for Q & A and discussion about everything related to OpenText Gupta Team Developer, SqlBase, TD Mobile and Report Builder.
It is the alternative for the OpenText customer forums which can only be accessed with an active support contract.

Please register your account now. It will make you part of the active community.
Also, this guest message will not be displayed for registered users.

As a bonus, registered users have access to the 'Newsgroups' subforum, holding 10 years worth of posts from the good old Gupta newsgroups.

Having an account gives you the opportunity to ask questions and get help from others.
We hope this free gathering will help you and the community getting forward!

Best regards,
The forum site admins.

Accessing SQLBASE thru ODBC / OleDB problems

General discussion forum about all things SqlBase.
Post Reply
Dobby
Germany
Posts: 3
Joined: 24 Apr 2017, 11:52
Location: Salem Germany

Accessing SQLBASE thru ODBC / OleDB problems

Post by Dobby » 15 May 2017, 08:24

Good morning folks,

we would like to acces as an SQLBase 12.02.11086 through ODBC or OLEDB.

We experience some problems:

ODBC: We cannot retrieve reasonable Data from LONGBIN and LONGVAR columns

OLEDB: We cannot retrieve reasonable Data from NVARCHAR columns

Is there anything we shoul know about?

Thanks and regards
Dobby

Dave Rabelink
Founder/Site Admin
Netherlands
Posts: 234
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands
Contact:

Re: Accessing SQLBASE thru ODBC / OleDB problems

Post by Dave Rabelink » 26 Jun 2017, 05:17

What client so you use?
TD or other environment? Please specify the exact version.
Regards,
Dave Rabelink

Image
Join & participate on Team Developer Tips & Tricks Wiki
Download samples from TD Sample Vault
Videos on TDWiki YouTube Channel

Steve Leighton
Site Admin
New Zealand
Posts: 22
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand
Contact:

Re: Accessing SQLBASE thru ODBC / OleDB problems

Post by Steve Leighton » 04 Sep 2017, 05:34

Have tested both OLEDB with NVARCHAR columns and ODBC with LONGVAR from SQLServer --> SQLBase.

Assuming you are using SQLServer ? If so are you using a Linked Server ?

If so , this syntax seems to work ok:

Code: Select all

SELECT * FROM OPENQUERY( LinkedServerName , 'Select NVARCHAR_Column from TableOwner.Table')
What's your OLEDB driver version ? SQLBASEOLEDB.dll should be at least 12.0.1 dated 01.09.2016
Best wishes
Steve
Bankside Systems Ltd. ( New Zealand )
www.banksidesystems.co.uk

Post Reply

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest