Question

在DW中asp与access连接失败

"driver={microsoft access driver(*.mdb)};dbq="&server.mappath("database/login.asa")

Answer 1

DW中ASP链接access，有点问题，我以前也出现这个问题过，它支持绝对路径的连接字符串比如：driver={microsoft access driver (*.mdb)};dbq=D:\My work\db1.mdb，但你那句IIS也认可，你可以编辑的时候用绝对路径的，上传或测试的时候用你的相对路径的。

Answer 2

dim Data_Path,Data_Pass
Data_Path = "Data/Data.asa"
Data_Pass = "DiuKai.Com"

driveS = "provider=microsoft.jet.oledb.4.0;data source="&server.mappath(Data_Path)
'driveS = "Driver={Microsoft Access Driver (*.mdb)};PWD=" & Data_Pass & ";dbq=" & server.mappath(Data_Path)
'driveS = "Provider=Microsoft.Jet.OleDB.4.0;Data Source=" & server.mappath(Data_Path) & ";Persist Security Info=False;Jet OLEDB:Database Password=" & Data_Pass

Answer 3

其中 Db = "../data/bbs.mdb"中的../data/bbs.mdb,你可以改成你要打开的数据库的名称~!
-----------------------
Dim Db
Db = "../data/bbs.mdb"
Dim ConnStr
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnStr
--------------------------------