朋友给了我一套SAP网站程序,我在本机上调试,其他很正常,会员能注册和操作,但我以管理员身份登陆总是提示:密码错误.无法登陆,更无法进入后台.
本机为WINXP,安装了IIS+SQL2000.数据是从.bak文件恢复的,没有出现问题.我在数据库里修改了原来的admin密码,结果还是密码错误,反复几天,我都快晕倒了.特向大家请教.万分感谢!
下面是const.asp里的连接代码,大家帮我看看有没有问题:
<%
strSQLServer="(local)"
strSQLUser="admin"
strSQLPassword="200208"
strSQLDataBase="db"
connstr = "driver={SQL Server};server=" & strSQLServer & ";UID=" & strSQLUser & ";PWD=" & strSQLPassword & ";database=" & strSQLDataBase & ""
set conn = server.createobject("ADODB.CONNECTION")
if err.number<>0 then
err.clear
set conn=nothing
response.write "<script>alert('Create ADO object failure');</script>"
response.end
else
conn.open connstr
if err.number<>0 then
err.clear
set conn=nothing
response.write "<script>alert('SQL Server db connect failure');</script>"
response.end
end if
end if
%>
<%
sql="select * from config"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
%>