Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a 64-bit Windows 7 laptop that I use for development.
I have office 2003 installed, because I have a client that works with Office 2003.

Microsoft Access is not installed, because it's my firm belief it's a piece of ehm non-optimal software.

I need to read a .mdb file written in Access.
The client wants me to read a few columns from this file into a different database.

I cannot get ODBC to connect to the database.
If I go to settings-> system -> ODBC enter image description here

and double click on MS-Access I get an error:

No routines for setting up ODBC for MS Access drivers (*.mdb) are found. Reinstall the drivers.

Installing 32-bit drivers does not help
I've gone to: http://www.microsoft.com/download/en/details.aspx?id=13255
And downloaded the 32-bit drivers and installed those, restarted the computer.
This does not help, the problem persists unchanged.

Installing 64-bit drivers is not allowed
enter image description here

Running the BDE-Administrator does not work either
BDE plays nice with me, but hangs when I want to save the settings.

How do I get access to that *.mdb file?
I'd like to use ODBC, but I'm open to any and all workarounds.
I'd like to connect using Delphi XE2 or Delphi-2007.

share|improve this question
    
Have you tried running a repair or reinstall of office 2003? –  Coding Gorilla Oct 7 '11 at 14:50
    
what do things look like when you go to c:\windows\syswow64 and run odbcad32 –  tony roth Oct 7 '11 at 15:08

1 Answer 1

There are two ODBC dialogs on your system. One for 32bit and one for 64bit. The one you can reach via system control is the 64bit one.

The 32bit version is located at

  • C:\WINDOWS\SYSTEM32\ODBCAD32.EXE (on a 32bit Windows)
  • C:\WINDOWS\SYSWOW64\ODBCAD32.EXE (on a 64bit Windows)
share|improve this answer
    
its the one in the syswow64 dir and its odbcad32.exe –  tony roth Oct 7 '11 at 15:18
    
@tonyroth Already found out on my 32bit machine. Will edit that. –  mailq Oct 7 '11 at 15:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.