Question

asp连接access数据库时提示ADODB.Connection (0x800A0E7A) 未找到提供程序。该程序可能未正确安装。怎办？

连接数据库的代码如下：
Dim conn,strConn
Set conn=Server.CreateObject("ADODB.Connection")
strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("address.mdb")
conn.Open strConn

Answer 1

Dim conn,strConn
Set Conn = Server.CreateObject("ADODB.Connection")
strConn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("address.mdb")
Conn.Open strConn

这样看看可以不~