ODBC driver problem

[arifkapucu79]

Hi,
I would like to add USER DSN for Access. When i clicked ADD button, I could not see "Microsoft Access driver (*.mdb)".
In the "User Data Sources" titled listbox, I see the "Microsoft Access driver (*.mdb)". But when i click it, i get an error:

"The setup routines for the Microsoft Access Driver (*.mdb, *.accdb) ODBC driver could not be found. Please reinstall the driver"

I installed SQL Server client tool but it could not be repaired.
How can i solve this?

Note: I use Windows Server 2003 x64

Thanks

 

[k5tm]

Are you using 64-bit SQL Server?

Tom Morrison

http://www.liant.com

 

[ArtieChoke]

You need to download the mdac package from Microsoft to get those drivers.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[arifkapucu79]

Yes. I'm using 64-bit SQL Server and i have installed mdac.
But the problem wasn't solved.

Thanks

 

[k5tm]

64-bit will not communicate with the 32-bit odbc driver manager. I don't think there is a 64-bit Access, is there?

Tom Morrison

http://www.liant.com