Recent

Author Topic: Parameter 0 is of type Unknown, which not supported yet  (Read 2603 times)

bigeno

  • Sr. Member
  • ****
  • Posts: 266
Parameter 0 is of type Unknown, which not supported yet
« on: February 14, 2016, 11:10:26 pm »
Next problem  :D
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

  • Sr. Member
  • ****
  • Posts: 266
Re: Parameter 0 is of type Unknown, which not supported yet
« Reply #1 on: February 16, 2016, 02:03:29 pm »
Ok, I found solution. Microsoft Access ODBC driver require schema.ini file (for txt,csv) with defined fields properities before connect.

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: Parameter 0 is of type Unknown, which not supported yet
« Reply #2 on: February 17, 2016, 09:04:06 am »
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
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

bigeno

  • Sr. Member
  • ****
  • Posts: 266
Re: Parameter 0 is of type Unknown, which not supported yet
« Reply #3 on: February 17, 2016, 09:14:19 am »
Because ODBC is API for various DBMSs. If I provide ODBC connection I want to connect maximum DB that is possible.

 

TinyPortal © 2005-2018