UC知道一个奇怪的asp问题
来源：百度知道 编辑：UC知道 时间：2024/06/10 12:38:14
set conn=server.CreateObject("adodb.connection")
dbpath=server.MapPath("留言版.mdb")
conn.open ("driver={microsoft access driver (*.mdb)};dbq="& dbpath)
s="select * from note_comment where id='"& 12 &"'"
set rs=conn.execute (s)
conn.close
上面这段程序到底哪错了?
dbpath=server.MapPath("留言版.mdb")
conn.open ("driver={microsoft access driver (*.mdb)};dbq="& dbpath)
s="select * from note_comment where id='"& 12 &"'"
set rs=conn.execute (s)
conn.close
上面这段程序到底哪错了?
set conn = server.createobject("adodb.connection")
conn.open = "provider=microsoft.jet.oledb.4.0;"&"data source = "&server.mappath("留言版.mdb")
If Err Then
err.Clear
Set conn = Nothing
Response.Write "数据库连接出错，请检查连接字串。"
Response.End
End If
s="select * from note_comment where id='12'"
set rs = conn.execute(s)
Set conn = Nothing
set conn=server.createobject("ADODB.CONNECTION")
dbpath=server.MapPath("留言版.mdb")
connstr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source =" & dbpath
conn.open connstr
s="select * from note_comment where id=12"
set rs=conn.execute (s)
试一下这个
关键是这一句
s="select * from note_comment where id=12"
一般在 server.MapPath("") 里的都是相对路径 ("../XXX.mdb")
s="select * from note_comment where id=12"
c