Question

在Dreamweaver的数据库里怎么连接access 数据库

在Dreamweaver数据库中，数据库在F:\asp项目\data\db1.mdb 中，连接字符串如下
"Deiver={Microsoft Access Driver (*.mdb)};DBQ=F:\asp项目\data\db1.mdb;Uid=;Pwd=;"
然后点 测试服务器上的驱动，他就报错说 是HTTP错误500，内部服务器错误。怎么回事
iis 什么的都配置好了

Answer 1

1.
set dbconnection=Server.CREATEOBJECT("ADODB.CONNECTION")
DBPath = Server.MapPath("customer.mdb")
dbconnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
SQL="select * from auth where id="" & user_id &"""
SET uplist=dbconnection.EXECUTE(SQL)

2.
set dbconnection=Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("customer.mdb")
dbconnection.Open "provider=microsoft.jet.oledb.4.0;data source="&dbpath
SQL="select * from auth where id="" & user_id &"""
SET uplist=dbconnection.EXECUTE(SQL)

3.
DBPath = Server.MapPath("customer.mdb")
set session("rs")=Server.CreateObject("ADODB.Recordset")
" rs=Server.CreateObject("ADODB.Recordset")
connstr="provider=microsoft.jet.oledb.4.0;data source="&dbpath
SQL="select * from auth where id="" & user_id &"""
session("rs").Open sql,connstr,1,3

4.
建odbc源xxx
set conn=server.createobject("Adodb.connection")
conn.open "DSN=xxx;UID=;PWD=;Database=customer

四种方法 地址，多看看http://hi.baidu.com/stone198912/blog/item/2049b865f05f35c380cb4a3f.html

Answer 2

你都打错了，Driver

Answer 3

不要用中文