[unixODBC-support] unixODBC Text DSN - How do I use it ?
wmealing at gmail.com
Tue Jun 28 02:13:35 BST 2005
The methods below are only what I have gathered by reading the
documentation and fudging through the source code, I cant seem to find
much on the correct way to use unixODBC Text DSN.
Ive tried to do some very basic SQL on both Red Hat Enterprise Linux
3 and Red Hat Enterprise Linux 4 ( unixODBC-2.2.9-1 ) with the same
Here is what I have done.
# cat /etc/odbc.ini
Description = Text
Driver = Text
Directory = /tmp/odbctest/
ReadOnly = No
CaseSensitive = No
Catalog = No
ColumnSeperator = |
# cat /etc/odbcinst.ini
FileDSNPath = /tmp/
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes
Pooling = No
Description = ODBC for Text Files
Driver = /usr/lib/libodbctxt.so
Setup = /usr/lib/libodbctxtS.so
FileUsage = 1
# cat /tmp/odbctest/hello
SQL> select * from hello
[ISQL]ERROR: Could not SQLPrepare
Doesnt seem to be a permission problem, can anyone tell me what I am
doing wrong ?
More information about the unixODBC-support