Recent

Author Topic: How to configure Todbcconnection???  (Read 7243 times)

Anonymous

  • Guest
How to configure Todbcconnection???
« 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:

brianlai

  • Guest
Re: How to configure Todbcconnection???
« Reply #1 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

Anonymous

  • Guest
RE: Re: How to configure Todbcconnection???
« Reply #2 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...?

:(

HowardH

  • New Member
  • *
  • Posts: 16
    • http://www.celtic-fiddler.com
RE: Re: How to configure Todbcconnection???
« Reply #3 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.
Howard Lee Harkness
The Celtic Fiddler http://www.celtic-fiddler.com
Violins and Accessories