ASP连接ACCESS数据库问题，急...

来源：百度知道 编辑：UC知道 时间：2024/06/17 22:34:09
'Dim connstr,db,strsql,rs,admin,adminpassword,wtitle,fenye,tongguo,leader,colleague,student,leaderp,colleaguep,studentp,teacherp,newscore,teacherscore,Password
'Dim visit_number,i,j,k,suiji,usertype,sql
'连接ACCESS数据库
connstr="DBQ="+server.mappath("database/hrbu.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)}"
Set db= Server.CreateObject("ADODB.Connection")
'db.open "Database=Hrbu;Uid=sa;Pwd=;Driver={SQL Server};Server=HRBU\Q"
'连接SQLSERVER2000数据库
db.open connstr
strsql="select * from admin"
set rs=db.execute(strsql)
admin=rs("adminname")
adminpassword=rs("adminpassword")
wtitle=rs("wtitle")
FENYE=RS("FENYE")
TONGGUO=RS("TONGGUO")
LEADER=RS("LEADER")
COLLEAGUE=RS("COLLEAGUE")
STUDENT=RS("STUDENT")
LEADERP=RS("LEADERP")
CO

连接ACCESS数据库
connstr="DBQ="+server.mappath("database/hrbu.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)}"
Set db= Server.CreateObject("ADODB.Connection")
db.open connstr
strsql="select * from admin"
set rs=db.execute(strsql)
admin=rs("adminname")
adminpassword=rs("adminpassword")
wtitle=rs("wtitle")
FENYE=RS("FENYE")
.....
....
...

http://hi.baidu.com/luckhui/blog/item/221747b5464280cf36d3cab2.html

没看完.应该是这错误吧.
connstr="DBQ="+server.mappath("database/hrbu.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)}"
改为:
connstr="DBQ="&server.mappath("database/hrbu.mdb")&";DRIVER={Microsoft Access Driver (*.mdb)}"

如果是 名称重定义