How to configure Todbcconnection???
lazarus / 16-Databases

----------------------------------------------------------------------
Anonymous · 2006-06-07 14:49

I want to configure todbcconnection with MSAccess.  Anyone can tell me
how to configure it...!

Million thanks.

:oops:

----------------------------------------------------------------------
brianlai · 2006-06-09 07:25

Quote from: "Anonymous"I want to configure todbcconnection with
MSAccess.  Anyone can tell me how to configure it...!

Million thanks.

:oops:

I can make todbcconnection working as following,

1) Set "Driver" as "Microsoft Access Driver (*.mdb)"
2) Add "DBQ=c:\xxx\xxx\xxx.mdb" in "Params"

Then I can set it active without any issues...  I hope it can help.

----------------------------------------------------------------------
Anonymous · 2006-06-11 18:04

Thanks a lot...  I can make the todbcconnection working now.  However
another problem occurs.  When I use tsqlquery to achieve the data from
ms access database, it prompts "unknown field type : @fieldname@"
which is a date/time field.  So how to solve it...?

----------------------------------------------------------------------
HowardH · 2007-01-03 21:45

Anybody here ever use TODBCConnection on a CSV file? I see a MS driver
for txt/csv, but I haven't been able to set it up.