杭州交通信息网红豆杉温泉花园:数据库连接错误 access 3704
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/27 18:43:52
set conn=server.createobject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver(*.mdb)};dbq="&server.mappath("hsxshasp.mdb")
set rs=server.createobject("adodb.recordset")
rs.open "select * from hnovels",conn,1,1
rs.pagesize=12
rs.AbsolutePage=page
if err.number<>0 then
response.write "错误号：" &err.number&"<br>"
response.write "数据库连接状态：" & conn.state &"<br>"
response.write "错误信息："&Err.Description &"<BR> "
response.write "出错对象： " & Err.Source &"<BR>"
response.write "出错行：" & Err.Line & "<BR>"
response.write "记录集连接状态：" &rs.state &"<br>"
response.end
end if
显示为
3704
0
对象关闭时，不允许操作
ADODB.Recordset
0
请问这是怎么回事？如何解决？
conn.Open "driver={Microsoft Access Driver(*.mdb)};dbq="&server.mappath("hsxshasp.mdb")
我用这个是有时也是出错，
我就用这个出错少：
Dim db,conn
db=Server.MapPath("hnovels")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &db
set rs=server.createobject("adodb.recordset")
rs.open "select * from hnovels",conn,1,1
rs.pagesize=12
rs.AbsolutePage=page
if err.number<>0 then
response.write "错误号：" &err.number&"<br>"
response.write "数据库连接状态：" & conn.state &"<br>"
response.write "错误信息："&Err.Description &"<BR> "
response.write "出错对象： " & Err.Source &"<BR>"
response.write "出错行：" & Err.Line & "<BR>"
response.write "记录集连接状态：" &rs.state &"<br>"
response.end
end if
set con=server.CreateObject("ADODB.connection")
con.open "Provider=SQLOLEDB.1;password=sa;persist security info=true;user ID=sa;initial catalog=3w;data source=."
上面是con的连接数据库的代码！
你把SQL 改成ACCESS就成了！