IISÎÞ·¨·ÃÎÊasp£¡Ìáʾ£ºServer Application Error
IISÎÞ·¨·ÃÎÊasp£¡
½â¾ö°ì·¨£¡½ñÌì´ò¿ªµçÄÔ·¢ÏÖIISÎÞ·¨·ÃÎÊaspÒ³Ãæ¡£
Ìáʾ£ºServer Application Error È»ºó¾ÍÓÐÁËÏÂÃæµÄÒ»¶Î»°¡£
The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance.
ÔÚÍøÉϲéÁ˲é½â¾ö·½°¸ÈçÏÂ:
Ê×ÏÈÊÇasp³ÌÐò£¬ËÀÑ»·£¬ÒªÇ󣺿´Ò»ÏÂÄãµÄÒ³Ã涨ÒåͬÃûrsÊDz»ÊÇÌ«¶àÁË,±ÈÈçSet rs=Server.CreateObject("ADODB.Recordset")
Èç¹ûÌ«¶à,ÓпÉÄÜ»á·þÎñÆ÷±»Ëùס,½â¾ö°ì·¨,
1¡¢È¡²»Ò»ÑùµÄÃû×Ö£¬ÈçSet rs1=Server.CreateObject("ADODB.Recordset")
Set rs2=Server.CreateObject("ADODB.Recordset")
2¡¢°ÑSet rs=Server.CreateObject("ADODB.Recordset")·ÅÔÚÒ³Ãæ×²¿£¬Ã¿¸ö¶¼¿ÉÒÔµ÷Ó㬰ÑÆäËû¶àÓàµÄɾµô
»òÕߣºÔÚÒ³ÃæÖÐÏÔʽµØÊÍ·Å×ÊÔ´£º
rs.close
set rs=nothing
conn.close
set conn=nothing
1¡£ÓÒ¼üÎҵĵçÄÔ--¹ÜÀí--±¾µØÓû§ºÍ×飬¸øIUSR_»úÆ÷ÃûºÍIWAM_»úÆ÷ÃûÁ½¸öÓû§ÉèÖÃÃÜÂ룬ҪһÑù¡£
2¡£¿ªÊ¼--ÔËÐÐ--´òcmd£¬
È»ºócd D:InetpubAdminscripts£¨ÎÒµÄϵͳÔÚDÅÌ£©£¬
È»ºócscript.exe adsutil.vbs set w3svc/wamuserpass ÄãµÄÃÜÂ룬
È»ºócscript.exe adsutil.vbs set w3svc/anonymoususerpass ÄãµÄÃÜÂë
¿´Ò»Ï£¬ÐÐÁËûÓУ¿Èç¹û»¹²»ÐУ¬ÄÇô
cscript.exe synciwam.vbs -v£¬
È»ºóiisreset¡£
¾Ý˵¾Í¿ÉÒÔÁË,µ«Êǵ½×îºóÒ»²¿Ìáʾ8004e00fµÄ´íÎó,´Ë´íÎóÊÇMSDTC·þÎñ²»Õý³£Ôì³ÉµÄ,½â¾ö·½·¨:
Ê×ÏȽøÈë×é¼þ·þÎñ£¬²é¿´×é¼þ·þÎñ/¼ÆËã»ú/ÎҵĵçÄÔ/COM+Ó¦ÓóÌÐò£¬½á¹û±¨´í“COM+ ÎÞ·¨Óë Microsoft ·Ö²¼Ê½ÊÂÎñе÷³ÌÐò½»Ì¸”£¬ÎÞ·¨²é¿´ÀïÃæµÄ¶ÔÏó¡£
2¡¢½øÈëʼþ²é¿´Æ÷£¬·¢ÏÖmsdtc·þÎñûÓÐÕý³£Æô¶¯¡£
3¡¢É¾³ý×¢²á±íÖеļü£º
? HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesMSDTC
? HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTC
? HKEY_CLASSES_ROOTCID
4¡¢Í£Ö¹MSDTC·þÎñ£ºnet stop msdtc
5¡¢Ð¶ÔØMSDTC·þÎñ£ºmsdtc -uninstall
6¡¢ÖØа²×°MSDTC·þÎñ£ºmsdtc -install
7¡¢È·ÈÏÔÚʼþ²é¿´Æ÷ÖÐmsdtc·þÎñÒѾÕý³£Æô¶¯[Õâ²½ºÜ¹Ø¼ü£¬Èç¹ûûÓУ¬ÖØÐÂÆô¶¯ÏµçÄÔ¿´¿´]
8¡¢ÖØÐÂÉèÖÃIISµÄIWAMÕ˺ÅÃÜÂë¡£[ÔÚ¼ÆËã»ú¹ÜÀí
Ïà¹ØÎĵµ£º
Array()
¡¡¡¡FUNCTION: ·µ»ØÒ»¸öÊý×é
¡¡¡¡SYNTAX: Array(list)
¡¡¡¡ARGUMENTS: ×Ö·û£¬Êý×Ö¾ù¿É
¡¡¡¡EXAMPLE: <%
¡¡¡¡Dim myArray()
¡¡¡¡For i = 1 to 7
¡¡¡¡Redim Preserve myArray(i)
¡¡¡¡myArray(i) = WeekdayName(i)
¡¡¡¡Next
¡¡¡¡%[/IMG]
¡¡¡¡RESULT: ½¨Á¢ÁËÒ»¸ö°üº¬7¸öÔªËصÄÊý×émyArray
¡ ......
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%response.ContentType ="application/vnd.ms-excel"
%>
<%
Set xlApplication = Server.CreateObject("Excel.Application") 'µ÷ÓÃexcel¶ÔÏó
xlApplication.Visible = False 'ÎÞÐè´ò¿ªexcel
xlApplication.SheetsInN ......
aspÁ¬½ÓaccessºÍmssqlµÄÍòÄÜ´úÂ룺
'½â¾öÁËACCESSÊý¾Ý¿â·¾¶µÄÎÊÌ⣡
'²ÉÓÃDBType=0»òDBType=1À´Çø·ÖAC¿â»¹ÊÇMSSQL¿â
'¾ßÌå²ÉÓÃAC¿âʱӦעÒâµÄÊÂÏÇë¿´³ÌÐò˵Ã÷
-----------------------------------------------
Dim DBType,Conn,StrConn
DBType=0 '0ΪAccessÊý¾Ý¿â£¬1ΪMSSQLÊý¾Ý¿â
If(DBType=0) Then
......
Ò»¡¢conn.asp
<%
'@Language="VBSCRIPT" CODEPAGE=65001
'meta http-equiv="Content-Type" content="text/html; charset=gb2312"
' 936 utf-8
class TDB
function qry(byval sqlquery)
& ......
HTML:
<META HTTP-EQUIV="pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache, must-revalidate">
<META HTTP-EQUIV="expires" CONTENT="Wed, 26 Feb 1997 08:21:57 GMT">
<META HTTP-EQUIV="expires" CONTENT="0">
PHP£º
header("Expires: Mon, 26 Jul 1997 ......