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;Da
'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 ,回车运行就可解决问题