Question

求：Dreamweaver与Access数据库连接字符串？

Answer 1

<%
dim sitename,powered
powered=" - Powered by hoogl"
sitename="联系系统"&powered
dim stime,db,conn,typess
stime=timer()
typess=1
db="./datebase/xiaohua.mdb"//数据库的地址
select case typess
case "1" 'access数据库
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source="&server.mappath(db)
case "2" 'sql数据库
set conn=server.createobject("adodb.connection")
conn.open "driver=SQL Server;uid=sa;pwd=;SERVER=local;database=aa"
end select
%>

Answer 2

DBQ=db.mdb;DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)}
其中db.mdb是数据名