Question

asp连接有密码的access数据库问题。

<%
dim conn
set conn = server.createobject("ADODB.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+server.MapPath(database)+";"
%>

这是连接数据库的文件代码，access数据库文件密码应该放在哪？

Answer 1

<%
dim conn
set conn = server.createobject("ADODB.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+server.MapPath(database)+";Jet OLEDB:Database Password=密码"
%>
或者:
<%
dim conn
set conn = server.createobject("ADODB.connection")
conn.open "provider=microsoft.jet.oledb.4.0;password=12345678;data source= "+server.MapPath(database)+";"
%>
或者:
<%
dim conn
set conn = server.createobject("ADODB.connection")
conn.open "dbq="+server.mappath(dbpath)+";driver={microsoft access driver (*.mdb)}；pwd=12345678;"
%>

一个个试试