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

0
votes

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...

1
ms-accessiisasp-classiciis-7.5
"I installed "Microsoft Access Database Engine 2010 Redistributable" 64bit" - Okay , then if you want to use it your driver string needs to be Driver={Microsoft Access Driver (*.mdb, *.accdb)}. And remember: You shouldn't be using an Access database as the back-end of a web application. – Gord Thompson
Also, I do believe, if you use the search facility, you will find many questions on this subject on S.O. – Paul
Thank you @GordThompson adding *.accdb solve the problem !!! – almoujtahed
@Paul no such question similar to this specific issue... anyway try it your self, if you find any... post it here rather than sharing your wisdom – almoujtahed
This thread has a similar issue. This thread gives other clues. This one may also help. More?... – Paul

1 Answers

2
votes

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)}.