但是,既使不要那一行,就是说在SQL查询器里可以查出结果,用ASP程序后,还是报ADODB.Recordset 错误 '800a0e78' 对象关闭时,不允许操作。ASP调用程序为
<%set conn=server.CreateObject("ADODB.connection")
conn.ConnectionString="Provider=SQLOLEDB.1;Data Source=136.5.63.143;pwd=cqnmc;uid=sa;Initial Catalog=CQNMC"
conn.Open
%>
<%set rs=server.createobject("adodb.recordset")
sql="ss7..huawei_dest " & first_yy_string & "," & first_mm_string & "," & first_dd_string & "," & first_hh_string & "," & end_hh_string & "," & scopestr
conn.CommandTimeout = 18000
Server.ScriptTimeout = 18000set rs = conn.execute(sql)%>
<%if rs.eof then
%>执行到if那一行时报的错。
<%set conn=server.CreateObject("ADODB.connection")
conn.ConnectionString="Provider=SQLOLEDB.1;Data Source=136.5.63.143;pwd=cqnmc;uid=sa;Initial Catalog=CQNMC"
conn.Open
%>
<%set rs=server.createobject("adodb.recordset")
sql="ss7..huawei_dest " & first_yy_string & "," & first_mm_string & "," & first_dd_string & "," & first_hh_string & "," & end_hh_string & "," & scopestr
conn.CommandTimeout = 18000
Server.ScriptTimeout = 18000set rs = conn.execute(sql)%>
<%if rs.eof then
%>执行到if那一行时报的错。
两个的值书不是超出了int的范围
-2147483648 到 2147483647