握不住的他 萧萧:求ASP连接到Access的代码!

来源:百度文库 编辑:高校问答 时间:2024/05/03 00:44:53

ODBC链接:access "Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;"
OLEDB链接:access "Provider=microsoft.jet.oledb.4.0;data source=your_database_path;user id=admin;password=pass;"

<%
Db="data.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
Connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
Conn.Open Connstr
%>

<%
Db="data.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
Connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
Conn.Open Connstr
%>