ASP连接数据库

连接代码

<%
dim conn,connstr,db
db="db.accdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath(db)
conn.Open connstr
%> 
VB
<%
dim conn,connstr,db
db="db.accdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath(db)
conn.Open connstr
%> 

需要以下驱动

https://www.microsoft.com/zh-CN/download/details.aspx?id=13255

发表评论