[freetds] [FreeTDS] ERROR: CLI describe error: [unixODBC][Driver Manager]Driver does not support this function

stock shoeeo at yahoo.com
Thu Sep 24 23:17:48 EDT 2009


Hi,

    I had install unixODBC-2.2.15pre with freetds-patch (v0.82). have try both tsql and isql and both able to connect to the database and working correctly.

    i am using ms sql 2005 developer edition

    im using a 3rd party tool on top of the ODBC with freeTDS driver. 

    the senario was, i try to create a tmp table and copy record from ms sql 2005 table into the tmp table, it hit ERROR: CLI describe error: [unixODBC][Driver Manager]Driver does not support this function.

i check on the unixODBC tracefile, it show [ODBC][835672][1253740371.704023][SQLColAttribute.c][293]
Entry: 
Statement = 11048e950 
Column Number = 1 
Field Identifier = SQL_DESC_UPDATABLE 
Character Attr = 0 
Buffer Length = 0 
String Length = 700000000a962b0 
Numeric Attribute = 700000000ab56a0
[ODBC][835672][1253740371.704058][SQLColAttribute.c][611]Error: IM001
[ODBC][835672][1253740371.704130][SQLGetDiagRec.c][758]
Entry: 
Statement = 11048e950 
Rec Number = 1 
SQLState = 700000000a95f88 
Native = 700000000a95f84 
Message Text = 700000000a95fb4 
Buffer Length = 513 
Text Len Ptr = 700000000a95f80
[ODBC][835672][1253740371.704172][SQLGetDiagRec.c][795]
Exit:[SQL_SUCCESS] 
SQLState = IM001 
Native = 700000000a95f84 -> 0 
Message Text = [[unixODBC][Driver Manager]Driver does not support this function]
 
from the log, it seem like unixODBC is not supporting the function and i do not know how to read tdsdump file, however i had been told that my other collagues had use unixODBC with another driver to connect to sybase and other database and perform the same thing. current i was finding which part had appear error.
 
attached with the log file, trc.log is unixODBC trace log, test_mssql.log is 3rd party tools log.
 
Regards,
Lawrance



      
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test_mssql.log
Type: application/octet-stream
Size: 849 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20090924/9e69d759/attachment-0003.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tdsdump.745566.log
Type: application/octet-stream
Size: 21561 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20090924/9e69d759/attachment-0004.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: trc.log
Type: application/octet-stream
Size: 38656 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20090924/9e69d759/attachment-0005.obj 


More information about the FreeTDS mailing list