How do I run classic ASP with Jet.OLEDB.4.0 in 64b

2019-09-17 16:37发布

I am getting "ADODB.Connection error '800a0e7a'" error when I run the following classic ASP code.

   Db = "db.mdb"
   ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
   set conn=server.createobject("ADODB.CONNECTION")
   conn.open Connstr

So..I googled the error code. The cause is that there is no 64bit Microsoft.Jet.OLEDB.4.0. I googled for a solution, but I only found how to resolve this error with visual studio.

How do I configure classic ASP in 64bit windows 7 (running IIS 7.5) to run the above code?

1条回答
We Are One
2楼-- · 2019-09-17 17:23

I have run into this problem in past and it's quite confusing to resolve. Please make sure you have latest version of MDAC installed on the server. It should resolve your issue.

查看更多
登录 后发表回答