UC知道asp连接access错误。
来源：百度知道 编辑：UC知道 时间：2024/05/05 12:10:45
<%
db="jj.mdb"
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("InfoPublish.mdb")
exec="select url from jj where name=" & 2
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
if(rs.eof()) then url = rs(0)
if( isnull(url )) then
else
response.redirect(url)
end if
%>
这是源码，下面是报错信息
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0xab4 Thread 0xe78 DBC 0x10e1a4c Jet'。
/conn_jj.asp, 第 4 行
小弟才疏学浅，望高人指教
db="jj.mdb"
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("InfoPublish.mdb")
exec="select url from jj where name=" & 2
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
if(rs.eof()) then url = rs(0)
if( isnull(url )) then
else
response.redirect(url)
end if
%>
这是源码，下面是报错信息
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0xab4 Thread 0xe78 DBC 0x10e1a4c Jet'。
/conn_jj.asp, 第 4 行
小弟才疏学浅，望高人指教
db="jj.mdb"
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("InfoPublish.mdb")
exec="select url from jj where name=" & 2
改为
db="jj.mdb"
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath(db)
exec="select url from jj where name='" & 2 & "'"
再试试看
db="jj.mdb"
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("InfoPublish.mdb")
你怎么有两个数据库?
为什么只用后面一个呢?那么前面一个呢?
exec="select url from jj where name=2"