dim conn
dim connstr
dim db
db="数据库路径/数据库"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
<%
dim conn
dim connstr
dim db
db="*.mdb" 数据库文件位置
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
On Error Resume Next
conn.Open connstr
if Err.Number<>0 then
Response.Write "数据连接失败..."
end if
sub CloseConn()
conn.close
set conn=nothing
end sub