帮忙看看access的连接错误阿！急阿

Maggiew 2003-08-19 10:08:40

asp文件全文：
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Set Cnn = Server.CreateObject("ADODB.connection")
set rs=Server.Createobject("ADODB.Recordset")
CnnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("result.mdb")
response.Write(CnnStr)
Cnn.open CnnStr
rs.open "Select * From record"
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>

</body>
</html>
错误：
Error Type:
ADODB.Recordset (0x800A0E7D)
The connection cannot be used to perform this operation. It is either closed or invalid in this context.

如果没有rs.open "Select * From record"
网页就不会报错
似乎也不会是数据库的问题，因为我曾经把数据库放在别的地方，或是用别的数据库测试都是这样的错误。
大家帮我看看可能的原因吧。谢谢啦

...全文

29 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

aBoris 2003-08-19

打赏
举报

<%
Dim conn
Dim connstr
connstr = "DBQ=" + server.mappath("result.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
if err.number<>0 then
err.clear
set conn=nothing
response.write "数据库连接出错！"
Response.End
else
conn.open connstr
if err then
err.clear
set conn=nothing
response.write "数据库连接出错！"
Response.End
else
rs.open "Select * From record",conn,1,1
end if
end if

%>

lhc521 2003-08-19

打赏
举报

我想你用以下的方法可能能连接上啊
Set Myconn=Server.CreateObject("ADODB.Connection")
Myconn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("result.mdb")
set rs=server.createobject("adodb.recordset")
sql="select * from record "
rs.open sql ,Myconn

zhengbenben 2003-08-19

打赏
举报

<%
Set Cnn = Server.CreateObject("ADODB.connection")
CnnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("result.mdb")
Cnn.open CnnStr
set rs=Server.Createobject("ADODB.Recordset")
Sql = "Select * From record"
Rs.open sql,cnn,1,1

%>

业余程序员 2003-08-19

打赏
举报

快点接贴不行的话QQ:55653793

业余程序员 2003-08-19

打赏
举报

set con=server.createobject("ADODB.CONNECTION")
connstr="driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("mail.mdb")
con.open connstr
set otb=con.execute("select * from mail")

diya 2003-08-19