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
- Founder/Site Admin
- Posts: 3145
- Joined: 24 Feb 2017, 09:12
- Location: Gouda, The Netherlands
TD or other environment? Please specify the exact version.
- Site Admin
- Posts: 274
- Joined: 05 Mar 2017, 20:57
- Location: Tauranga, New Zealand <--> Stroud, England
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')
Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand
Who is online
Users browsing this forum: [Ccbot] and 0 guests