Page 1 of 1
getting this error while reading data from SQL Server
Posted: Thu Apr 19, 2012 8:43 am
by bhs
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)
Posted: Wed May 09, 2012 4:36 am
by HendrikB
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
Posted: Mon Jul 23, 2012 12:56 am
by sri_vin
Hi
Please check your SQL code. It might have some un-printable character in it. You may need to replace them.
regards
Sriram
Posted: Mon Jul 23, 2012 7:40 am
by chulett
This suggests it is not a data issue.
Posted: Tue Jul 31, 2012 1:01 pm
by leomauer
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>
....