aspÄÜÖ´Ðж¯Ì¬T-SQLÂð£¿
Ö±½ÓÔÚsqlÓï¾äÖÐд£º sql= " declare @1 nvarchar(max),@2 nvarchar(max£©...... " È»ºó Rs.open sql,CONN,3,2 Response.Write Rs.recordcount µ«ÊÇûÓдò¿ª£¬±¨´í ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. ÊDz»ÊÇÒªÓô洢¹ý³Ì²Å¿ÉÒÔѽ£¿ ÔÚasp.netÖÐÊÇ¿ÉÒÔÖ±½ÓÔÚsqlÀïÃæÄÇÑùдµÄ¡£
³Ô·¹»ØÀ´¹Ø×¢¡£ CONN.execute sql ²»ÐÐ ¡£ÒýÓà CONN.execute sql »¹ÊDZ¨´í ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. ÒýÓà ÒýÓà 2 Â¥ hookee µÄ»Ø¸´: CONN.execute sql »¹ÊDZ¨´í ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. ²Ù×÷±»¾Ü¾ø£¡ÔÚ¶ÔÏóÒѹرյÄʱºò ±¨Ê²Ã´´í? Á¬½Ó´®µÄÕʺÅÒªÓÐ×ã¹»µÄȨÏÞÖ´ÐвÙ×÷ ÒÔϲâÊÔ¿ÉÒÔ VBScript code: sql= " declare @1 nvarchar(max), @2 nvarchar(max);" Set conn = CreateObject("ADODB.Connection") conn.Open "Provider=SQLOLEDB;Data source=127.0.0.1;Initial Catalog=DB;User ID=sa;Password=sa;" conn.Execute sql conn.Close {{---
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï° http://www.hxzi.com/view/61402.html B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
conn.asp <% Set Conn=Server.CreateObject("ADODB.Connection") Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath("Connt ......
<%if request.QueryString("start") <>"" then%> <%if cint(start)>0 then%> <a href="search.asp?q= <%=q%>&start= <%if request.Query ......
½¨ÁËÒ»¸öÕ¾µã£¬ÀïÃæÓÐ login.aspx. events.aspx µÈµÈ ÆäËûµÄÒ³Ãæ¡£ µ«ÊÇÎÒµ÷ÊÔ ÆäËûÒ³ÃæµÄʱºò£¬±Ä³öÀ´µÄ×ÜÊÇ login.aspx Ò³Ãæ¡£ ¸Õѧasp ÇëÖ¸½Ì ÄãÉèÖÃÆðʼҳÁ˰ɡ£¡£ ¶÷ÔõôȡÏûÄØ£¿ Òªµ ......
Òª×öÒ»¸öweb¿ØÖÆÏµÍ³£¬Ò³Ãæ¿ò¼ÜÈçÏ£º ×ó±ßÊÇ¿ØÖƲ˵¥£¬¿ÉÒÔÏÂÀ£¬ÓÒ±ßÊÇÿ¸ö¾ßÌåÒ³Ãæ£¬ÒªÇó¿ØÖƲ˵¥Ê¼ÖÕÔÚÒ³Ãæ×ó±ß£¬Ö»ÊÇÔÚÓÒ±ßˢоßÌåÒ³Ãæ¡£ ¸ßÊÖ°ïæ£¬ÔõôʵÏÖ£¿ ÓдúÂë×îºÃ£¡ Çë¸ßÊÖ°ïæ£¡ ......