数据库连接的问题,救命!
<%
on error resume next

dim conn

set conn=server.CreateObject( "ADODB.connection ")

conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ= " & Server.MapPath( "数据库试题.mdb ")
'conn.open "Provider=Microsoft.Jet.OLEDB.4.0;User Id=admin;Data Source= "& Server.MapPath( "数据库试题.mdb ")

set rsLogin=server.CreateObject( "adodb.recordset ")
sql= "select 用户名,密码,身份 from 用户表 "
rsLogin.open sql,conn,1,1
rsLogin.movefirst
user_name=rsLogin.field(0)
user_pwd=rsLogin.field(1)
user_identity=rsLogin.field(2)
%>

<script language= "javascript ">
alert ( <%=user_name%> );
alert ( <%=user_pwd%> );
alert ( <%=user_identity%> );
</script>

结果是三个对话框都是空的,我想应该是数据库连接有问题,但代码没错啊,数据源也设置了,有人说是temp文件夹的问题,我设置了everyone为可写入啊,但还是不行.还有那个用户表中是绝对有数据的

[解决办法]
两个变量能通用??
response.write user_name&user_pwd&user_identity& " <br> "
[解决办法]
<script language= "javascript ">
alert ( " <%=user_name%> ");
alert ( " <%=user_pwd%> ");
alert ( " <%=user_identity%> ");
</script>
[解决办法]
on error resume next注释掉
在后面加上这段代码看看是什么问题再问
<%
if err.number <> 0 then
response.write err.description
end if
%>