Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005

来源:百度知道 编辑:UC知道 时间:2024/05/12 16:59:30
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/conn.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT * FROM cesidb"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)
MM_valUsername=CStr(Request.Form("textfield"))
If MM_valUsername <> "" Then
MM_fldUserAuthorization=""
MM_redirectLoginSuccess="a.souye/a.souye/souye

很明显,这是你的<!--#include file="Connections/conn.asp" --> 文件的驱动问题,如果原始的连接字符串如下,你自己对照:
(1)
'一般采用的方法
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(strDB)
(2)
'如果服务器采用较老版本Access驱动,请用下面连接方法
"driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath(strDB)
其中strDB是数据库文件的路径.

如果你现在用的是(2),说明是老版本驱动的原因,换成(1)的字符串,问题会解决的.你上面这段DW生成的代码没有问题.