asp 连接数据库access

来源:百度知道 编辑:UC知道 时间:2024/07/01 13:51:26
DB_CONNECTION_STRING = "DBQ=" & Server.MapPath("./data/#EsCms_net.mdb")}; Driver={Microsoft Access Driver (*.mdb)

请问这里怎么弄啊,这个好象是错的!

<%
'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)};"