UC知道ASP 网页问题, 高手快来,急啊!
来源：百度知道 编辑：UC知道 时间：2024/06/26 00:21:10
出现问题：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
/liuyan/del.asp，行 8
del.asp的文件源码 ：1---25行代码如下：
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connectionsuyan.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_liuyan_STRING
Recordset1.Source = "SELECT * FROM liuyan"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
id=request("id")
connstr="driver={microsoft access driver (*.mdb)};dbq="&server.mappath("liuyan")
set conn=server.createobject("adodb.connection")
conn.open connstr
set rs=server.cre
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
/liuyan/del.asp，行 8
del.asp的文件源码 ：1---25行代码如下：
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connectionsuyan.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_liuyan_STRING
Recordset1.Source = "SELECT * FROM liuyan"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
id=request("id")
connstr="driver={microsoft access driver (*.mdb)};dbq="&server.mappath("liuyan")
set conn=server.createobject("adodb.connection")
conn.open connstr
set rs=server.cre
这一句有问题:
Recordset1.ActiveConnection = MM_liuyan_STRING
应为
SET Recordset1.ActiveConnection = 数据库的CONNECTION对象
你上边语句中的MM_liuyan_STRING应该是个字符串变量
<!--#include file="../Connectionsuyan.asp" --> 先问你这个包含进来的文件是不是数据库链接文件(代码)?
如果是,请检查链接数据代码,建议用字符串链接,代码格式如下,自己修改:
<%Dim DB,Conn
DB = "db.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DB)
%>
2-如果不是,请把这段代码调到前面,因为服务器解释ASP是从上到下顺序的(?)
<%
connstr="driver={microsoft access driver (*.mdb)};dbq="&server.mappath("liuyan")
set conn=server.createobject("adodb.connection")
conn.open connstr
%>
connstr="driver={microsoft access driver (*.mdb)};dbq="&server.mappath("liuyan") '这里错了liuyan没有后缀,应该是liuyan.mdb或者是liuyan.asp之类的.