[unixODBC-support] Text driver: Could not SQLPrepare

Radev, Lubomir lradev at corelogic.com
Wed Feb 1 21:25:19 GMT 2012

I'm using 2.2.14p2 on Ubuntu with the text driver from 2.2.11 (since it's absent from later releases).

Trying to test read plain CSV data in isql, I'm getting this: 

SQL> select * from SampleData.csv
[-----][unixODBC]START: hStmt = 0x809eff0 nAttribute = 10010
[-----][unixODBC]END: Attribute not supported.
[-----][unixODBC]START: hStmt = 0x809eff0 nAttribute = 10011
[-----][unixODBC]END: Attribute not supported.
[-----][unixODBC]START: hStmt = 0x809eff0 nAttribute = 10012
[-----][unixODBC]END: Attribute not supported.
[-----][unixODBC]START: hStmt = 0x809eff0 nAttribute = 10013
[-----][unixODBC]END: Attribute not supported.
[-----][unixODBC]hStmt = 0x809eff0
[-----][unixODBC]syntax error processing 'select' on line 1
[ISQL]ERROR: Could not SQLPrepare

Here's my /etc/odbcinst.ini:

Description             = text driver
Driver          = /usr/local/lib/libodbctxt.so
Driver64                = /usr/lib
Setup           = /usr/local/lib/libodbctxtS.so
Setup64         = /usr/lib
UsageCount              = 1
CPTimeout               =
CPReuse         =

...and my ~/.odbc.ini:

Description             = ~/.odbctxt
Driver          = text
Directory               =
ReadOnly                = Yes
CaseSensitive           = No
Catalog         = No
ColumnSeperator         = ,

Any clues as to what might be the problem?

This message may contain confidential or proprietary information intended only for the use of the 
addressee(s) named above or may contain information that is legally privileged. If you are 
not the intended addressee, or the person responsible for delivering it to the intended addressee, 
you are hereby notified that reading, disseminating, distributing or copying this message is strictly 
prohibited. If you have received this message by mistake, please immediately notify us by  
replying to the message and delete the original message and any copies immediately thereafter. 

Thank you. 

More information about the unixODBC-support mailing list