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.

 

 

Advertisements

One Response to “Classic ASP and Access under Windows 7 x64”

  1. Ezzat Says:

    Thanks ,It helped me too much

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: