2007 Access 数据库链接
<%
dim conn
dim connstr
dim db
db="/database/shopInfo.accdb" '数据库文件的位置'
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.[color=red]Ace[/color].OLEDB.[color=red]12.0[/color];Data Source=" & Server.MapPath(db)
conn.Open connstr
sub CloseConn()
conn.close
set conn=nothing
end sub
%>
2003 Access 数据库链接
<%
dim conn
dim connstr
dim db
db="/database/shopInfo.accdb" '数据库文件的位置'
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.[color=red]Jet[/color].OLEDB.[color=red]4.0[/color];Data Source=" & Server.MapPath(db)
conn.Open connstr
sub CloseConn()
conn.close
set conn=nothing
end sub
%>
<%
dim conn
dim connstr
dim db
db="/database/shopInfo.accdb" '数据库文件的位置'
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.[color=red]Ace[/color].OLEDB.[color=red]12.0[/color];Data Source=" & Server.MapPath(db)
conn.Open connstr
sub CloseConn()
conn.close
set conn=nothing
end sub
%>
2003 Access 数据库链接
<%
dim conn
dim connstr
dim db
db="/database/shopInfo.accdb" '数据库文件的位置'
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.[color=red]Jet[/color].OLEDB.[color=red]4.0[/color];Data Source=" & Server.MapPath(db)
conn.Open connstr
sub CloseConn()
conn.close
set conn=nothing
end sub
%>