Parameter 0 is of type Unknown, which not supported yet
lazarus / 16-Databases

----------------------------------------------------------------------
bigeno · 2016-02-14 22:10

Next problem 
After correctly connected to Microsoft TXT,DBF ODBC driver I get:
Parameter 0 is of type Unknown, which not supported yet

when try to execute "Select * from y:\example.txt"

my connection string:
'DefaultDir=Y:\'
'DBQ=Y:\'
'AUTOCOMMIT=1'

----------------------------------------------------------------------
bigeno · 2016-02-16 13:03

Ok, I found solution. Microsoft Access ODBC driver require schema.ini
file (for txt,csv) with defined fields properities before connect.

----------------------------------------------------------------------
mangakissa · 2016-02-17 08:04

Why using odbc connection for csv/txt if you can create a parser for
your files. Now you have to create a schema what's excatly the same.
I also know there's a package for FPC to read txt/csv files without
odbc

----------------------------------------------------------------------
bigeno · 2016-02-17 08:14

Because ODBC is API for various DBMSs. If I provide ODBC connection I
want to connect maximum DB that is possible.