ÔÚxpϵͳϰ²×°iis²¢Çҳɹ¦µÄÔËÐÐaspÎļþ
1.ÔÚÎҵĵçÄÔÓÒ¼üµÄ”¹ÜÀí“ÖÐÕÒµ½“±¾µØÓû§ºÍ×锣¬È»ºóµ¥»÷”Óû§“£¬ÔÚÓұ߻ῴµ½Ò»¸ö½Ð"IWAM_20020101-0024"µÄÓû§£¬ÕâÊÇiiis°²×°Ê±×Ô¼º´´½¨µÄÄÚÖÃÕË»§£¬µãÓÒ¼ü“ÉèÖÃÃÜÂ딣¬µã¼ÌÐø£¬È»ºóÊäÈë“ÐÂÃÜÂ딺͓ȷÈÏÃÜÂ딡£“IWAM_20020101-0024”ÊÇÓÐIWAM-ÄãµÄ¼ÆËã»úÃû£¬´´½¨³öÀ´µÄ¡£ÎҵļÆËã»úÃûΪ“20020101-0024”£¬ËùÒÔ¾ÍÊÇ“IWAM_20020101-0024”
2.°´windows+R½¡£¬ÊäÈëcmd£¬È»ºóÔÙÊäÈë“cd c:\inetpub\adminscripts”,È»ºóÔÙÊäÈë adsutil SET w3svc/WAMUserPass Password ,Password²ÎÊý¾ÍÊÇÒªÉèÖõÄIWAMÕ˺ŵÄеÄÃÜÂë,±ØÐëºÍ"IWAM_20020101-0024"µÄÓû§ÉèÖõÄÃÜÂëÒ»ÖÂ
3.ͬ²½com+Ó¦ÓóÌÐò£¬ÔÚ”¹ÜÀí“ÖÐÕÒµ½“×é¼þ·þÎñ”£¬ÔÚ“¿ØÖÆÌ¨¸ùĿ¼”ÖУ¬ÕÒµ½“×é¼þ·þÎñ”£¬ÔÚ“¼ÆËã»ú”ÖÐÕÒµ½"ÎҵĵçÄÔ"£¬ÔÚ“com+Ó¦ÓóÌÐò”ÖÐÕÒµ½“O ut-Of-Process Pooled Applications”£¬µãÓÒ¼üÑ¡”ÊôÐÔ“µÄ“±êʾ”£¬°Ñ“ϵͳÕÊ»§”Ñ¡ÖУ¬Ñ¡ÖГ½»»¥Ê½Óû§”£¬°´“È·¶¨”¼´¿É
4.°´windows+R½¡£¬ÊäÈëcmd£¬È»ºóÔÙÊäÈë“cd c:\inetpub\adminscripts”,È»ºóÔÙÊäÈë "cscript c:\inetpub\adminscripts\synciwam.vbs -v“ ,»á³öÏÖMicrosoft (R) Windows Script Host Version 5.6 °æÈ¨ËùÓÐ(C) Microsoft Corporation 1996-2000¡£±£ÁôËùÓÐȨÀû¡£ WamUserName:IWAM_MYSERVER WamUserPass:Aboutnt2001 IIS Applications Defined: Name, AppIsolated, Package ID w3svc, 0, {3D14228C-FBE1-11d0-995D-00C04FD919C1} Root, 2, IISHelp, 2, IISAdmin, 2, IISSamples, 2, MSADC, 2, ROOT, 2, IISAdmin, 2, IISHelp, 2, Root, 2, Root, 2, Out of process applications defined: Count: 1 {3D14228D-FBE1-11d0-995D-00C04FD919C1} Updating Applications:£¬È»ºó¾Í³É¹¦ÁË¡£
×¢Ò⣺
1.Èç¹ûȱÉÙµÚ3²½¾Í»á±¨8004EooFµÄ´íÎó
2.Èç¹ûÔÚµÚ3²½µãcom+Ó¦ÓóÌÐòʱ±¨´íÎ󣬴íÎóºÅΪ8004EooF£¬½â¾öµÄ°ì·¨Êǰ´window+R½¡ÊäÈëmsdtc -resetlog£¬¾ÍºÃÁË
3.Èç¹ûÔÚµÚÈý²½¿´²»µ½“O ut-Of-Process Pooled Applications”£¬¾ÍÐèÒª°´window+R½¡ÊäÈëmsdtc -resetlog£¬È»ºóÐ¶ÔØiis£¬È»ºóÖØÐ°²×°iis£¬ÔÙÔÚ”¹ÜÀí“ÖÐÕÒµ½&
Ïà¹ØÎĵµ£º
Set xlApp = CreateObject("Excel.Application")
xlApp.DisplayAlerts = false '²»ÏÔʾ¾¯¸æ
'xlApp.Application = false ......
ActiveConnection ÉèÖûò·µ»ØCommand¶ÔÏóµÄÁ¬½ÓÐÅÏ¢£¬¸ÃÊôÐÔ¿ÉÒÔÊÇÒ»¸öConnection¶ÔÏó»òÁ¬½Ó×Ö·û´®¡£
CommandText ÉèÖûò·µ»Ø¶ÔÊý¾ÝÔ´µÄÃüÁî´®£¬Õâ¸ö´®¿ÉÒÔÊÇSQLÓï¾ä¡¢±í¡¢´¢´æ¹ý³Ì»òÊý¾ÝÌṩÕßÖ§³ÖµÄÈÎ ºÎÌØÊâÓÐЧµÄÃüÁîÎı¾¡£
Prepared Ìá³öÔÚµ÷ÓÃCommand¶ÔÏóµÄExecute·½·¨Ê±£¬ÊÇ·ñ½«²éѯµÄ±àÒë½á¹û´¢´æÏÂÀ´¡£Èç¹û½«¸ ......
ºÜ¶àʱºò,ÎÒÃDzÉÓÃÔʼµÄ·½·¨À´½â¾öÒ»ÐÐÄÚÑ»·3ÕÅͼƬ,Èç¹ûÉÏ´«ÕßÖ»ÉÏ´«ÁË2ÕÅͼƬ,ÄÇô2ÕÅͼƬ¼äµÄ¾àÀë»áºÜ´ó,ÒòΪȱÉÙÁËÒ»¸ö<td> </td>.
<table border="0" cellpadding="0" cellspacing="0">
<%
dim rs,sqltext
set rs = Server.CreateObject("adodb.recordset")
sqltext="sel ......
ÔÚ¶àÏîÑ¡ÔñµÄһЩӦÓÃÖУ¬¿ÉÒÔÓöþ½øÖÆ1´ú±íÑ¡ÖУ¬0´ú±í²»Ñ¡¡£ÀýÈç¸øÄ³Óû§½ÇÉ«·ÖÅäȨÏÞabcdefg£¬Ñ¡ÖÐÇé¿öÊÇ1001101£¬ÄÇô´Ë½ÇÉ«°üº¬ËÄÏîȨÏÞ£¬ÓÃÒ»¸ö±äÁ¿±íʾ£¬ÏàÓ¦µÄÊ®½øÖÆÊýÊÇ77¡£
µ«ÊÇ£¬ÔÚASPÖеĶàÏîÑ¡Ôñ£¬¾Í²»ÊʺÏÕâÖÖÒÔÊýÖµµÄÐÎʽ¼Ç¼ѡÖÐÇé¿ö¡£ÒòΪ£¬µ±ÏîÄ¿ÊýºÜ¶àʱ£¨ÀýÈç6 ......
1.ÊýÖµÐͺ¯Êý£º abs(num): ·µ»Ø¾ø¶ÔÖµ sgn(num): num>0 1; num=0 0; num<0 -1;ÅжÏÊýÖµÕý¸º hex(num): ·µ»ØÊ®Áù½øÖÆÖµ Ö±½Ó±íʾ£º&Hxx ×î´ó8λ oct(num): ·µ»Ø°Ë½øÖÆÖµ Ö±½Ó±íʾ£º&Oxx ×î´ó8λ sqr(num): ·µ»ØÆ½·½¸ù num>0 int(num): È¡Õû int(99.8)=99; int(-99.2)=100 fix(num): È¡Õû fix(99.8)=99; fix ......