28,391
社区成员
发帖
与我相关
我的任务
分享
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("data.mdb")
ACCESS连接数据库字符串
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("asptest.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn
set rs=server.CreateObject("adodb.recordset")
sql="select * from table "
rs.open sql,conn,1,1
或
Set Cnn = Server.CreateObject("ADODB.Connection")
StrCnn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source ="&Server.MapPath("johnny\asptest.mdb")
//带密码情况
//Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\data.mdb;Persist Security Info=False;Jet OLEDB:Database Password=11
Cnn.Open StrCnn
sql="select * from table "
set rs=Cnn.execute(sql)