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 {{---
Ïà¹ØÎÊ´ð£º
conn.asp <% Set Conn=Server.CreateObject("ADODB.Connection") Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath("Connt ......
<%On Error Resume Next Set conn=Server.CreateObject("ADODB.Connection") conn.begintrans conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
ÓÉÓÚ¶ÔÒ³ÃæÊ¹ÓÃÁËα¾²Ì¬ ²¢ÇÒ¶ÔID½øÐÐÁ˼ÓÃÜ¡£ Ö÷Òª´úÂëÈçÏ£º httpd.ini RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I] ³ÌÐò´úÂë AΪ¼ÓÃÜ£¬BΪ½âÃܺ¯Êý <a href=&q ......
ÓÐÄÄλ¸ßÊÖÓùýASP FCKÔÚÏß±à¼Æ÷ѽ£¬ËüÄǸöͼƬÉÏ´«¹¦ÄÜÔõôÅäÖÃѽ ÄܸøÎÒ·¢¸öÄÜÓÃFCKÔÚÏß±à¼Âð£¿Ò»¶¨ÄÜÉÏ´«Í¼Æ¬¹¦ÄܵÄѽ£¬¼±Ñ½ Ö±½Óµ½¹Ù·½ÍøÕ¾È¥Ï¸ö¾Í¿ÉÒÔÁË£¬¹ØÓÚÉèÖÃô£¬Ö±½ÓGOOGLEÒ»ÏÂÄãµÄ°æ±¾ºÅ¾Í¿ÉÒÔÕÒµ ......
Ò»¶Îʱ¼äºó ¾Í²»ÄÜÓõÄÄÇÖÖ ¿ÉÒÔÓÃ×é¼þдÂð? ×é¼þ ÊDz»ÊDZØÐëÏÈÔÚ·þÎñÆ÷°²×° ²ÅÄÜʹÓÃ? ÄÇÓÃÐéÄâÖ÷»úµÄ ²»¾ÍûϷÁË.... ewebeditor¾ÍÊÇҪע²á²ÅÄÜÓÃµÄ Ã²ËÆÊÇûɶÓõ ......