getting this error while reading data from SQL Server

bhs · Post by **bhs** » Thu Apr 19, 2012 8:43 am

ODBC_Connector_56,0: ODBC function "SQLGetData" reported: SQLSTATE = 07009: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid Descriptor Index (CC_OdbcInputStream::getTotalSize, file CC_OdbcInputStream.cpp, line 349)

HendrikB · Post by **HendrikB** » Wed May 09, 2012 4:36 am

Hi bhs,

getting the same error message today when reading a nvarchar(max) column out of SQL Server using ODBC connector.

Your workaround may help me.

Thanks and regards,
Hendrik

sri_vin · Post by **sri_vin** » Mon Jul 23, 2012 12:56 am

Hi

Please check your SQL code. It might have some un-printable character in it. You may need to replace them.

regards
Sriram

chulett · Post by **chulett** » Mon Jul 23, 2012 7:40 am

This suggests it is not a data issue.

leomauer · Post by **leomauer** » Tue Jul 31, 2012 1:01 pm

Today we got the same error and learned that varchar(max) is treated as CLOB (text) field and has to go to the bottom of the Select statement:
SELECT
<all non CLOB fields>
<all CLOB fields>
FROM
<table name>
....