UC知道asp错误,缺少语句
来源：百度知道 编辑：UC知道 时间：2024/05/14 13:24:58
01: <HTML>
02: <HEAD>
03: <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
04: <TITLE>EX11-07B.asp 更新类别信息的内容-取出类别信息</TITLE>
05: </HEAD>
06: <BODY>
07: <%
08: strDSN="DSN=deary;uid=deary;pwd=23924400"
09: TableName = "产品类别"
13: Set OBJConn = Server.CreateObject("ADODB.Connection")
14: OBJConn.Open strDSN
15: strSQL = "Select * From " & TableName & " Where 产品名称='" & Request.Form("ClassifyNo") & "'"
16: Set Rs = OBJConn.Execute ( strSQL )
17: Response.Write "SQL Query 的内容：<BR><B><I>" & strSQL & "</I></B>"
18: If Not Rs.Eof Then
19: %>
20: <form method='post' id=form2 name=form2 Action="c.asp">
21: <table Border=1 align="center">
22: <Tr><Td cols
02: <HEAD>
03: <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
04: <TITLE>EX11-07B.asp 更新类别信息的内容-取出类别信息</TITLE>
05: </HEAD>
06: <BODY>
07: <%
08: strDSN="DSN=deary;uid=deary;pwd=23924400"
09: TableName = "产品类别"
13: Set OBJConn = Server.CreateObject("ADODB.Connection")
14: OBJConn.Open strDSN
15: strSQL = "Select * From " & TableName & " Where 产品名称='" & Request.Form("ClassifyNo") & "'"
16: Set Rs = OBJConn.Execute ( strSQL )
17: Response.Write "SQL Query 的内容：<BR><B><I>" & strSQL & "</I></B>"
18: If Not Rs.Eof Then
19: %>
20: <form method='post' id=form2 name=form2 Action="c.asp">
21: <table Border=1 align="center">
22: <Tr><Td cols
数据库连接语句出错，你按以下的方法连接数据库吧！
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={SQL Server};server=服务器IP;uid=deary;pwd=23924400;database=数据库名"
也不知道你是哪行错了,应该把错误信息也贴出来!
没关系,先检查你的数据库连接问题吧
dim conn
dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr="driver={sql server};server=(local);uid=sa;pwd=1234;database=zuoyefeng.com"
conn.Open connstr