<%@ Language="JScript" %>
<%
//import java.sql.*;
//import java.net.URL;
var Msg;
var conn;
var userid=Request("userid");
var pw=Request("pw");var conn = new ActiveXObject("ADODB.CONNECTION");
strconn ="DBQ="+Server.MapPath("kagebookdata_Data.MDF")+";DefaultDir=;Driver={SQL Server};server=(local);user id=sa;pw=;";
conn.Open(strconn); var rs = new ActiveXObject("ADODB.RECORDSET");
sql = "select * from users where userid=1";
rs.open(sql,conn);
if (!(rs.BOF && rs.EOF)){
if (pw == rs("pw") && userid == rs("userid")){
Msg = "恭喜你," + username + "你已经成功登陆!";
conn=1;
}else if(userid != rs("userid")){
Msg = "对不起,您填写的用户名不正确,请返回重新填写";
conn=2;
}else if(pw != rs("pw")){
Msg = "对不起,您填写的密码不正确,请返回重新填写";
conn=3;
}
}else{
Msg = "用户不存在,请注册!";
conn=4;
}
Response.write("conn=" + conn + "&output=" + Msg);%>错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]对象名 'users' 无效。
/WebApplication2/flash/return.asp, 第 16 行目录如下:
http://localhost/WebApplication2/flash/return.asp
flash文件夹下有" kagebookdata_Data.MDF " 数据文件.数据库中有 users 表啊,怎么任是无法找到.
见者快帮,急也.thanks
<%
//import java.sql.*;
//import java.net.URL;
var Msg;
var conn;
var userid=Request("userid");
var pw=Request("pw");var conn = new ActiveXObject("ADODB.CONNECTION");
strconn ="DBQ="+Server.MapPath("kagebookdata_Data.MDF")+";DefaultDir=;Driver={SQL Server};server=(local);user id=sa;pw=;";
conn.Open(strconn); var rs = new ActiveXObject("ADODB.RECORDSET");
sql = "select * from users where userid=1";
rs.open(sql,conn);
if (!(rs.BOF && rs.EOF)){
if (pw == rs("pw") && userid == rs("userid")){
Msg = "恭喜你," + username + "你已经成功登陆!";
conn=1;
}else if(userid != rs("userid")){
Msg = "对不起,您填写的用户名不正确,请返回重新填写";
conn=2;
}else if(pw != rs("pw")){
Msg = "对不起,您填写的密码不正确,请返回重新填写";
conn=3;
}
}else{
Msg = "用户不存在,请注册!";
conn=4;
}
Response.write("conn=" + conn + "&output=" + Msg);%>错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]对象名 'users' 无效。
/WebApplication2/flash/return.asp, 第 16 行目录如下:
http://localhost/WebApplication2/flash/return.asp
flash文件夹下有" kagebookdata_Data.MDF " 数据文件.数据库中有 users 表啊,怎么任是无法找到.
见者快帮,急也.thanks
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货