UC知道asp程序登录不了,帮看一下
来源：百度知道 编辑：UC知道 时间：2024/06/18 13:07:52
<%@ LANGUAGE = "VBScript" %>
<!--#include file="ADOVBS.INC"-->
<%
username=request("username")
password=request("password")
if username="" then
response.Write("<script>alert('用户名不能为空！');history.back()</script>")
response.End()
elseif password="" then
response.Write("<script>alert('密码不能为空！');history.back()</script>")
response.End()
end if
Set objConnection = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("db1.mdb")
objConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from admin where Username='"&username&"' and Password='"&password&"'"'根据条件建立查询
rs.open sql,objConnection,1,3
<!--#include file="ADOVBS.INC"-->
<%
username=request("username")
password=request("password")
if username="" then
response.Write("<script>alert('用户名不能为空！');history.back()</script>")
response.End()
elseif password="" then
response.Write("<script>alert('密码不能为空！');history.back()</script>")
response.End()
end if
Set objConnection = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("db1.mdb")
objConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from admin where Username='"&username&"' and Password='"&password&"'"'根据条件建立查询
rs.open sql,objConnection,1,3
呵呵。 这是因为 IIS用户没有添加写入权限。你可以常识在IIS配置里 增加 iis_user 写入 数据库对应的目录 db1.mdb 也就是它的写入权限
错误提示都说的很清楚了，就是数据库为只读，加上写入权限