[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