Search code examples
ms-accessiisasp-classiciis-7.5

Running classic asp & ms access 2000 on Windows server 2008 R2 64bit & IIS7.5

I have an old website that is built with classic asp and MS access 2000 and was running fine on an old server. I need it to work on new machine equipped with Windows Server 2008 R2 64bit & IIS7.5

I tested ASP classic and it is running fine on the new machine. What I am trying to do is to make connections with the ms access db.

I installed "Microsoft Access Database Engine 2010 Redistributable" 64bit and restarted the machine.

ASP code is something like this:

<%dim db
set db=server.createobject("adodb.connection")
db.open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("Staff.mdb")%>

I got the error message: "500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed."

Is there some kind of configuration I need to do on IIS or something...

Solution

  • Driver={Microsoft Access Driver (*.mdb)} is the ODBC driver name for the older "Jet" database engine. It ships with Windows, but it is only available to 32-bit applications and it only works with the older .mdb database file format.

    If you need to

    • work with an .mdb database from a 64-bit application, or
    • work with an .accdb database from any application

    then you need to have the newer Access Database Engine (a.k.a "ACE") installed, and your driver name needs to be Driver={Microsoft Access Driver (*.mdb, *.accdb)}.