在提交正常的SQL语句时,IE老是转个不停(无响应)....

Question

在新网购买的SQL服务器,在提交正常的SQL语句时,IE老是转个不停(无响应),然后刷新的话,整个网站后台就什么都看不见了,除非把IE关了重新打开一页.分析了一下程序,都是合法而且正确的,那我想是不是新网的SQL服务器有问题?该怎么解决?
注:在update的时候会出现这种情况.
谢谢大家.

Answer 1

你首先要确定，是不是sql服务器的问题！

Answer 2

<%
If request("action")="save" Then
weboff_on=Replace_Text(Request.Form("weboff_on"))
inform_y_n=Replace_Text(Request.Form("inform_y_n"))
inform=Request.Form("inform")
forum_setting=Replace_Text(Request.Form("forum_setting"))
UploadSetting=Replace_Text(Request.Form("UploadSetting"))
Uploadjpg=Replace_Text(Request.Form("Uploadjpg"))
Stopreadme=Request.Form("Stopreadme")
reg_y_n=Replace_Text(Request.Form("reg_y_n"))
WebName=Replace_Text(Request.Form("Webname"))
WebUrl=Replace_Text(Request.Form("WebUrl")) 
WebUrl1=Replace_Text(Request.Form("WebUrl1")) 
weburl2=Replace_Text(Request.Form("weburl2"))
userweb=Replace_Text(Request.Form("userweb")) 
SMTPServer=Replace_Text(Request.Form("SMTPServer"))
SystemEmail=Replace_Text(Request.Form("SystemEmail"))
Systemtel=Replace_Text(Request.Form("Systemtel"))
hottel=Replace_Text(Request.Form("hottel"))
hotfax=Replace_Text(Request.Form("hotfax"))
worldname=Replace_Text(Request.Form("worldname"))
Company=Replace_Text(Request.Form("Company"))
add=Replace_Text(Request.Form("add"))
yb=Replace_Text(Request.Form("yb"))
worldecfuwu=Replace_Text(Request.Form("worldecfuwu")) 
yhzh=Replace_Text(Request.Form("yhzh"))
bank=Replace_Text(Request.Form("bank"))
PicUrl=Replace_Text(Request.Form("PicUrl"))
LinkUrl=Replace_Text(Request.Form("LinkUrl"))
newspic=Replace_Text(Request.Form("newspic"))
bizrepic=Replace_Text(Request.Form("bizrepic"))
search=Replace_Text(Request.Form("search"))sql="select * from worldec_config where id=1"
Set rs= Server.CreateObject("ADODB.Recordset") 
rs.open sql,conn,1,3rs("weboff_on")=weboff_on
rs("inform_y_n")=inform_y_n
rs("inform")=inform
rs("forum_setting")=forum_setting
rs("UploadSetting")=UploadSetting
rs("Uploadjpg")=Uploadjpg
rs("Stopreadme")=Stopreadme
rs("reg_y_n")=reg_y_n
rs("WebName")=WebName
rs("WebUrl")=WebUrl 
rs("WebUrl1")=WebUrl1 
rs("weburl2")=weburl2
rs("userweb")=userweb 
rs("SMTPServer")=SMTPServer
rs("SystemEmail")=SystemEmail
rs("Systemtel")=Systemtel
rs("hottel")=hottel
rs("hotfax")=hotfax
rs("worldname")=worldname
rs("Company")=Company
rs("add")=add
rs("yb")=yb
rs("worldecfuwu")=worldecfuwu 
rs("yhzh")=yhzh
rs("bank")=bank
rs("PicUrl")=PicUrl
rs("LinkUrl")=LinkUrl
rs("newspic")=newspic
rs("bizrepic")=bizrepic
rs("search")=searchrs.update
rs.close
set rs=noting
conn.close
set conn=nothingresponse.write"<table cellpadding=2 cellspacing=1 border=0 width=400 class=tableBorder align=center>"
response.write"<TR>"
response.write"<TH class=tableHeaderText colSpan=2 height=25>保存网站信息</TH>"
response.write"<TR><tr><td height=85 valign=top class=forumRow><div align=center><br><br>网站配置保存成功！</div></td></tr>"
response.write"<tr align=center><td height=30 class=forumRowHighlight><a href='admin_setting.asp'>&lt;&lt; 返回上一页</a></td>"
response.write"</tr>"
response.write"</table>"
response.write"<br><br>"
end if
%>
==================================
谢谢

Answer 3

问题解决了,没错,是新网数据库设置的问题,他们数据库设置太BT了,在update时
rs.open sql,conn,1,3数据库锁定状态必须变成2,2才行.
=========================================================================
rs.open sql,conn,2,2