Classic ASP and Access under Windows 7 x64

Hi All,

A quick tip for those of you that want to run a classic ASP website using an access database under a 64-bit operating system; this doesn’t work out of the box.

The problem you’ll see is that IIS reports the driver as mismatched or missing. You’ll get one of these errors:

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

OR

Microsoft OLE DB Provider for ODBC Drivers error ’80004005′

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The reason is that there are no 64-bit odbc access drivers (yet). I read somewhere that Ofiice 2010 might have them, but for now, the solution is to run the application pool your website runs in, in 32-bit mode.

To do that, open IIS manager, in the treeview on the left go to the application pools and select the application pool your misbehaving website runs in. The advanced settings link on the right opens a popup where you can find an option to enable 32-bit applications. Set it to TRUE, recycle the pool, and your access driver/website should work.

 

 

Advertisement