Lazarus

Programming => Databases => Topic started by: Anonymous on June 07, 2006, 04:49:24 pm

Title: How to configure Todbcconnection???
Post by: Anonymous on June 07, 2006, 04:49:24 pm
I want to configure todbcconnection with MSAccess.  Anyone can tell me how to configure it...!

Million thanks.

:oops:
Title: Re: How to configure Todbcconnection???
Post by: brianlai on June 09, 2006, 09:25:13 am
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.

:D
Title: RE: Re: How to configure Todbcconnection???
Post by: Anonymous on June 11, 2006, 08:04:15 pm
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...?

:(
Title: RE: Re: How to configure Todbcconnection???
Post by: HowardH on January 03, 2007, 10:45:45 pm
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.
TinyPortal © 2005-2018