[unixODBC-support] Seting up unixODBC text file driver for basic tests

[Ravi Sharma]

Hi,

I installed unix odbc and trying to execute query on text file.
I was able to open a connection but when i am executing a query its throwing
error -

[unixODBC]START: hStmt = 0x82c7530 nAttribute = 10010

select * from hello

Here is my current configuration:
$ cat odbc.ini
[Text]
Description             = TextFile
Driver          = TextFile
Directory               = /tmp/odbcText
ReadOnly                = No
CaseSensitive           = Yes
Catalog         = No
ColumnSeperator         = ,

$ cat odbcinst.ini
[TextFile]
Description             = ODBC for text file tables
Driver          = /usr/local/unixODBC/lib/libodbctxt.so
Driver64                = /usr/local/unixODBC/lib/libodbctxt.so
Setup           = /usr/local/unixODBC/lib/libodbctxtS.so
Setup64         = /usr/local/unixODBC/lib/libodbctxtS.so
UsageCount              = 1
CPTimeout               =
CPReuse         =

I've tried placing these lines in file 'hello' as a test
id,name
1,mike
2,ed


Please help

Regards
ravi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20100318/1a411e88/attachment.html>