All Apps and Add-ons
Highlighted

DB Connect dbquery returning int but not varchar fields

Hi,
I just installed DB connect and am able to connect to Sybase. dbquery is returning all fields properly if I run select with int fields only. However, if the select has even one varchar field, then dbquery stops returning values the moment it encounters the first varchar field.

Please let me what I am doing wrong.

Thanks
Vineet

Tags (2)
0 Karma
Highlighted

Re: DB Connect dbquery returning int but not varchar fields

Ok, got the problem. I was using the Sybase driver to connect to the database. I thought the database was Sybase but it was actually SQL Anywhere. Hence the problem.
I installed the ODBC driver for SQL Anywhere and was able to connect through DB Connect using ODBC. All the queries are working fine now.

View solution in original post

0 Karma