永发信息网

为什么我用asp连接数据库页面总是卡死,我的代码如下:

答案:2  悬赏:80  手机版
解决时间 2021-01-24 23:08
  • 提问者网友:低吟詩仙的傷
  • 2021-01-24 03:56
<%
Const SqlDatabaseName = "ETE"
Const SqlPassword = "talent"
Const SqlUsername = "sa"
Const SqlLocalName = "ACER-PC\SQLEXPRESS"
a = request.Form("hiddenField")
response.Write(a)
Sub ConnectionDatabase
Dim ConnStr
dim sql
dim conrs
dim a
a = request.Form("hiddenField")
sql="SELECt usemodel FROM cnbe WHERe PN = " & a & ""
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ""
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
set conrs = server.CreateObject("adodb.recordset")
conrs.open sql,conn
do until conrs.EOF
for each x in conrs.Fields
Response.Write(x.name)
Response.Write(" = ")
Response.Write(x.value & "
")
next
Response.Write("
")
conrs.MoveNext
loop
conrs.close
conn.close
End Sub
call ConnectionDatabase
%>
最佳答案
  • 五星知识达人网友:長槍戰八方
  • 2021-01-24 05:30
看出错代码,出错的行。ie把脚本调试打开
全部回答
  • 1楼网友:猎心人
  • 2021-01-24 06:10
期待看到有用的回答!
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯