您所在位置：主题：关于数据库的连接问题
mythbobo
[专家分：0] 发布于 2007-04-02 11:10:00
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>管 理 员 资 料 修 改</title>
<style type="text/css">
<!--
table {
font-size: 12px;
}
-->
</style>
</head>
<%
if request.form("active")="yes" then
admin=trim(request.form("admin"))
password=trim(request.form("password"))
home=trim(request.form("home"))
homeurl=trim(request.form("homeurl"))
total=trim(request.form("total"))
page=trim(request.form("page"))
netname=trim(request.form("netname"))
qq=trim(request.form("qq"))
email=trim(request.form("email"))
note=trim(request.form("note"))
set rs2=createobject("adodb.recordset")
sqlstring="select * from admin"
rs2.open sqlstring,conn,1,3
rs2("admin")=admin
rs2("password")=password
rs2("home")=home
rs2("homeurl")=homeurl
rs2("total")=total
rs2("page")=page
rs2("netname")=netname
rs2("qq")=qq
rs2("email")=email
rs2("note")=note
rs2.update
rs2.close
conn.close
set rs2=nothing
set conn=nothing
response.redirect "index.asp"
else
%>
<body background="images/dw.gif">
<form name="form1" method="post" action="">
<table width="700" height="320" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#EFF1F3" style="border-right:1px #6699CC solid;border-left:1px #6699CC solid;border-bottom:1px #6699CC solid;">
<tr>
<td height="24" colspan="3" background="images/b1.gif"> <div align="center">管
理 员 资 料 修 改</div></td>
</tr>
<tr>
<td width="257"><div align="right">用户名:</div></td>
<td width="6"><div align="right"></div></td>
<td width="435"><input name="admin" type="text" value="<%=admin%>"></td>
</tr>
<tr>
<td><div align="right">密码:</div></td>
<td width="6"> </td>
<td width="435"><input name="password" type="text" value="<%=password%>"></td>
</tr>
<tr>
<td><div align="right">主页名称:</div></td>
<td width="6"> </td>
<td width="435"><input name="home" type="text" value="<%=home%>"></td>
</tr>
<tr>
<td><div align="right">主页地址:</div></td>
<td width="6"> </td>
<td width="435"><input name="homeurl" type="text" value="<%=homeurl%>" size="30"></td>
</tr>
<tr>
<td><div align="right">最大留言数:</div></td>
<td width="6"> </td>
<td width="435"><input name="total" type="text" value="<%=total%>"></td>
</tr>
<tr>
<td><div align="right">每页显示的留言数:</div></td>
<td> </td>
<td><input name="page" type="text" value="<%=pages%>">
<input type="hidden" name="active" value="yes"></td>
</tr>
<tr>
<td><div align="right">网名:</div></td>
<td> </td>
<td><input name="netname" type="text" id="netname" value="<%=netname%>"></td>
</tr>
<tr>
<td><div align="right">OICQ号码:</div></td>
<td> </td>
<td><input name="qq" type="text" id="qq" value="<%=qq%>"></td>
</tr>
<tr>
<td><div align="right">E-mail邮箱:</div></td>
<td> </td>
<td><input name="email" type="text" id="email" value="<%=email%>"></td>
</tr>
<tr>
<td><div align="right">说明:</div></td>
<td width="6"> </td>
<td width="435"><textarea name="note" cols="30" rows="3" id="note"><%=note%></textarea>
</td>
</tr>
<tr>
<td height="28" colspan="3"> <div align="justify">
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
<input type="button" name="Submit3" value="取消" onClick="history.back(-1)">
</div></td>
</tr>
</table>
<%end if%>
<!-- #include file="bottom.asp" -->
</form>
</body>
</html>
错误类型：
Microsoft JET Database Engine (0x80040E09)
不能更新。数据库或对象为只读。[/size][/size]
请各位高手们帮帮我解决!!谢谢!!
<!-- #include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>管 理 员 资 料 修 改</title>
<style type="text/css">
<!--
table {
font-size: 12px;
}
-->
</style>
</head>
<%
if request.form("active")="yes" then
admin=trim(request.form("admin"))
password=trim(request.form("password"))
home=trim(request.form("home"))
homeurl=trim(request.form("homeurl"))
total=trim(request.form("total"))
page=trim(request.form("page"))
netname=trim(request.form("netname"))
qq=trim(request.form("qq"))
email=trim(request.form("email"))
note=trim(request.form("note"))
set rs2=createobject("adodb.recordset")
sqlstring="select * from admin"
rs2.open sqlstring,conn,1,3
rs2("admin")=admin
rs2("password")=password
rs2("home")=home
rs2("homeurl")=homeurl
rs2("total")=total
rs2("page")=page
rs2("netname")=netname
rs2("qq")=qq
rs2("email")=email
rs2("note")=note
rs2.update
rs2.close
conn.close
set rs2=nothing
set conn=nothing
response.redirect "index.asp"
else
%>
<body background="images/dw.gif">
<form name="form1" method="post" action="">
<table width="700" height="320" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#EFF1F3" style="border-right:1px #6699CC solid;border-left:1px #6699CC solid;border-bottom:1px #6699CC solid;">
<tr>
<td height="24" colspan="3" background="images/b1.gif"> <div align="center">管
理 员 资 料 修 改</div></td>
</tr>
<tr>
<td width="257"><div align="right">用户名:</div></td>
<td width="6"><div align="right"></div></td>
<td width="435"><input name="admin" type="text" value="<%=admin%>"></td>
</tr>
<tr>
<td><div align="right">密码:</div></td>
<td width="6"> </td>
<td width="435"><input name="password" type="text" value="<%=password%>"></td>
</tr>
<tr>
<td><div align="right">主页名称:</div></td>
<td width="6"> </td>
<td width="435"><input name="home" type="text" value="<%=home%>"></td>
</tr>
<tr>
<td><div align="right">主页地址:</div></td>
<td width="6"> </td>
<td width="435"><input name="homeurl" type="text" value="<%=homeurl%>" size="30"></td>
</tr>
<tr>
<td><div align="right">最大留言数:</div></td>
<td width="6"> </td>
<td width="435"><input name="total" type="text" value="<%=total%>"></td>
</tr>
<tr>
<td><div align="right">每页显示的留言数:</div></td>
<td> </td>
<td><input name="page" type="text" value="<%=pages%>">
<input type="hidden" name="active" value="yes"></td>
</tr>
<tr>
<td><div align="right">网名:</div></td>
<td> </td>
<td><input name="netname" type="text" id="netname" value="<%=netname%>"></td>
</tr>
<tr>
<td><div align="right">OICQ号码:</div></td>
<td> </td>
<td><input name="qq" type="text" id="qq" value="<%=qq%>"></td>
</tr>
<tr>
<td><div align="right">E-mail邮箱:</div></td>
<td> </td>
<td><input name="email" type="text" id="email" value="<%=email%>"></td>
</tr>
<tr>
<td><div align="right">说明:</div></td>
<td width="6"> </td>
<td width="435"><textarea name="note" cols="30" rows="3" id="note"><%=note%></textarea>
</td>
</tr>
<tr>
<td height="28" colspan="3"> <div align="justify">
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
<input type="button" name="Submit3" value="取消" onClick="history.back(-1)">
</div></td>
</tr>
</table>
<%end if%>
<!-- #include file="bottom.asp" -->
</form>
</body>
</html>
错误类型：
Microsoft JET Database Engine (0x80040E09)
不能更新。数据库或对象为只读。[/size][/size]
请各位高手们帮帮我解决!!谢谢!!