asp 连接数据库access
来源:百度知道 编辑:UC知道 时间:2024/07/01 13:51:26
请问这里怎么弄啊,这个好象是错的!
<%
'on error resume next
dim rs
dim conn
dim connstr
dim dbpath
set conn=server.createobject("adodb.connection")
set rs=server.createobject("adodb.recordset")
DBPath = Server.MapPath("../data/news.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
'connstr = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("../data/news.mdb")
'conn.open connstr
'connstr="DBQ=" & server.mappath("../data/news.mdb") & ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
'conn.Open connstr
'connstr = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("../data/news.mdb")
'connstr = "DBQ=" & server.mappath("../data/news.mdb") & ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"