Accessing SQLBASE thru ODBC / OleDB problems

General discussion forum about all things SqlBase.
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
Founder/Site Admin
Netherlands
Posts: 261
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

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
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

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

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

Return to “General Discussion”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests