PDA

View Full Version : How to configure ODBC Data Source Administrator(DSA)?



dkjMusic
November 10th, 2010, 11:28 AM
I ultimately want to query an existing MS-Access database (say, contacts.mdb) from a Lazarus program I will write.

It appears that configuring a User DSN is the first step.

In the ODBC DSA, I am stuck at Adding a driver for MS-Access databases. What do I need to download for this?

P.S. I have Googled the subject and found several hits (including the MS Access Lazarus wiki) but none with the answer.

spjackson
November 10th, 2010, 01:12 PM
When I used to have anything to do with this stuff, the places I knew to get the ODBC driver for Access were Microsoft Office Professional, and Microsoft Visual Studio (possibly also MSDN Library). I don't know whether there's a free download - there didn't use to be.