Skip to Content
0
Dec 04, 2020 at 12:22 PM

odbc test fails with sybase IQ 16

37 Views Last edit Dec 04, 2020 at 12:23 PM 2 rev

We have a script written for odbc test. However, it fails with the below reason. Can you please suggest on the same ?

[myuser@COMP-3179-1 bin]$ ./odbctest

Registered Data Sources: CData_DSN (/opt/cdata/cdata-odbc-driver-for-sybaseiq/lib/libsybaseiqodbc.x64.so)

Server Name? CData_DSN

User ID? myuser

Password? mypassword

Error code -1: Native code -1 State S1000 The SQL Error Number is 9502, State is 0, Severity is 16, Error is 'SQL Anywhere Error -638: Right truncation of string data', Server name is , Line number is 0.

isql works fine and below are the other details on the same

[myuser@COMP-3179-1 bin]$ cat /etc/odbc.ini

[CData_DSN] Driver=/opt/cdata/cdata-odbc-driver-for-sybaseiq/lib/libsybaseiqodbc.x64.so

Description = My Description

User = myuser

Password = mypassword

Server = COMP-2747-1

Database = unicadevdb

[unicauser@COMP-3179-1 bin]$ isql CData_DSN -v

+---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL>