Running Access ODBC Drivers on Windows 7 64 bit version

Question

I currently build a "classic" ASP web application that uses a backend database of MS Access through an ODBC system DSN connection.  This works fine on all 32 bit platforms from XP, Vista and I can easily configure and run it with ODBC.

I am now trying to run the application with Windows 7 64 bit.  I have configured the 32 bit ODBC Access drivers instead of the 64 bit drivers by running the ODBC driver setup page at:

C:\Windows\SysWOW64\odbcad32.exe

When I try and running the web application that connects to the database, I get the error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

 

Is it possible to run the Access ODBC drivers (32 bit?) on Windows 7 64 bit?  Is there a 64 bit version of the driver available.

 

Answer 1

Is your web application configured to run in a 32-bit application pool? There is no direct way that 32-bit in-process components will be able to run from a 64-bit application pool (process).

---

Paul ~~~~ Microsoft MVP (Visual Basic)