学习asp时access数据库连接出错啦

来源:百度知道 编辑:UC知道 时间:2024/06/27 17:57:47
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
error code:
db="../databases/vip.mdb"
set vcon=server.createobject("adodb.connection")
vcon.connectionstring="driver={Microsoft Access Driver(*.mdb)};dbq="&server.mappath(db)

Const AccessPath="data"
Const AccessFile="mdb.mdb"

'定义数据库连接

Dim Conn
Set Conn= Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(AccessPath&"/"&AccessFile)
Conn.Open