Solution for ADODB.Connection Error ‘800a0e7a’

ADODB.Connection error '800a0e7a'

Error description:

When connecting ASP to Access database, the following error occurs:

ADODB.Connection error '800a0e7a'

Provider not found. The program may not be properly installed.

/conn.asp, line 12

Original code:

<%
dim conn
set coon=server.CreateObject("adodb.connection")
dim str
str="provider=Microsoft.jet.OLEDB.4.0;Data Source=" & server.mappath("blog_db.mdb")
'str="DBQ="&server.MapPath("blog_db.mdb")&";Driver={Mirosoft access driver(*.mdb)}"
coon.open str
%>

环境:

Windows 2003、IIS6.0、Access 2007(兼容2003)

 

故障解决方法:开始-运行-cmd,然后输入 cscript C:/inetpub/adminscripts/adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 true ,回车运行就可解决问题

Leave a Comment

Your email address will not be published.