打开数据库失败.请教!!!

[hfyanzi]

代码如下:

dim startime,conn,connstr,db,rs,rs_s,rs_s1
startime=timer()
db="user/database/#bio.mdb"
on error resume next
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
'connstr="DBQ="+server.mappath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr

set rs=server.createobject("adodb.recordset")
sql="select * from user "
rs.open sql,conn,1,1
if rs.recordsetcount=0 then
Response.Write "dddddddddddddddddddddd"
Response.Write Server.MapPath(db)
end if

rs.recordsetcount = < > 多少都打热行
Response.Write "dddddddddddddddddddddd"
Response.Write Server.MapPath(db)
这个语句
请问哪里有错

[rjzou2006]

没空

[moeryang]

连接字符创串错了直接用'connstr="DBQ="+server.mappath(""&db&"")+";DRIVER={Microsoft Access Driver (*.mdb)};"

[hfyanzi]

哥们还是不行呀

[xie_yanke]

set rs=server.createobject("adodb.recordset")
sql="select * from [user]"
rs.open sql,conn,1,1
if not (rs.eof or rs.bof) then
Response.Write "OK"
else
Response.Write "Error"
end if

[lkh42002]

rs.recordsetcount??

[擒兽]

ASP各种连接方式

http://feb-.blog.163.com/blog/static/1657789200682953216919

[hfyanzi]

连接还是不行
我这里的DB本身就是一个字符串,这种连接方式也没有错.

[xie_yanke]

sql="select * from [user]" user是保留字.