UC知道这个ACC数据库连接怎么转SQL连接？
来源：百度知道 编辑：UC知道 时间：2024/05/10 18:07:32
dim l_conn,l_connstr,l_db
l_db="data/Dv_Plus_Tools2.mdb"
Set l_conn = Server.CreateObject("ADODB.Connection")
l_connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(l_db)
l_conn.Open l_connstr
function l_CloseDatabase
l_Conn.close
Set l_conn = Nothing
End Function
%>
l_db="data/Dv_Plus_Tools2.mdb"
Set l_conn = Server.CreateObject("ADODB.Connection")
l_connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(l_db)
l_conn.Open l_connstr
function l_CloseDatabase
l_Conn.close
Set l_conn = Nothing
End Function
%>
<%
on error resume next
dim conn
dim dbpath
dbpath=server.mappath("uadmin/db/dbdb1.mdb")
set conn=server.createobject("adodb.connection")
'conn.open "Driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath
conn.open "Provider=Microsoft.Jet.Oledb.4.0;Data Source="&dbpath
%>