ASP.NETÖÐExcel: Access is deniedµÄÎÊÌâ½â¾ö
ÔÚASP.NETÖе÷ÓÃEXCEL×é¼þµÄʱºò,Èç¹ûûÓÐÅäÖÃDCOMÖÐEXCELȨÏÞÎÊÌâ,½á¹û³ÌÐò»á±¨:Access is denied.
½â¾öµÄ·½·¨ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖ£¬ÔÚweb.configÖÐÉèÖÃÒ»¸ö½Úµã.
<identity impersonate="true" />
²»¹ýÕâÖÖ·½·¨Ö»Äܽâ¾ölocalµçÄÔÉϵÄExcel Access is deniedµÄÎÊÌâ
Èç¹ûÊÇ·þÎñÆ÷µÄ»°,Óпͻ§»ú·ÃÎÊÒ³ÃæµÄʱºò,ͬÑùÕâÖÖÎÊÌ⻹ÊDz»Äܸù±¾µÄ½â¾öEXCELµÄȨÏÞÎÊÌâ
µÚ¶þÖÖ,ÅäÖÃDCOM
Èç¹ûÊdzÌÐò·ÅÔÚ·þÎñÆ÷¶Ë,µ«ÊÇPC¶ËÐèÒª·ÃÎÊ·þÎñÆ÷µÄ³ÌÐò,ÄÇÑùµÚÒ»ÖÖ·½·¨»¹ÊDz»Äܽâ¾ö,Ö»ÄÜÓÃÕâÖÖ·½·¨.
1. ÔËÐÐdcomcnfg´ò¿ª×é¼þ·þÎñ,ÒÀ´ÎÕ¹¿ª"Component Services"->"Computers"->"My Computer"->"DCOM Config"
2. ÕÒµ½"Microsoft Excel Application" ÓÒ¼ü´ò¿ªÊôÐÔ¶Ô»°¿ò,
3.Ñ¡Ôñ"Security"±êÇ©. ½«"Launch and Activation Permissions"Æô¶¯ºÍ¼¤»îȨÏÞ,"Access Permissions"·ÃÎÊȨÏÞ£¬¶¼ÉèΪ×Ô¶¨Ò壬Ȼºó½«System, INTERACTIVE,Everyone, Administrators, IUSR_<machinename>, IWAM_<machinename>ÕâЩÕÊ»§¶¼Ìí¼Ó½øÈ¥£¬²¢½«È¨ÏÞÈ«¸³¸øËûÃÇ¡£
4.È»ºóµ¥»÷È·¶¨,²¢¹Ø±Õ×é¼þ·þÎñ.
Ïà¹ØÎĵµ£º
×î½üÏîÄ¿ÖÐÐèÒªÓõ½urlrewriterÖØÐ´µÄ¹¦ÄÜ ¡£¡£ µ«ÊÇÔÚÖØÐ´ºóµÄurlÀïÈç¹û²úÉú»Ø·¢£¬url¾ÍÓֱ仨ÔÀ´µÄurl Á´½Ó¡£¡£
ÔÚÍøÉÏÕÒÁ˺þã¬ÖÕÓÚÕÒµ½Ò»¸ö¿ÉÒÔÕý³£Ê¹Óã¬ÓֱȽÏÈÝÒ×·½·¨¡£¡£ ºÙºÙ £¬×Ô¼º¼Ç¼һϰɡ£
ASP.NET URL Rewrite. URLÖØÐ´
URL ÖØÐ´ÊǽØÈ¡´«Èë Web ÇëÇó²¢×Ô¶¯½«ÇëÇóÖØ¶¨Ïòµ½ÆäËû URL µÄ¹ý³Ì¡£
± ......
1¡¢»ùÓÚASP.NET¼¼ÊõµÄÒ³Ãæ»º´æ
¡¡¡¡»ùÓÚASP.NET¼¼ÊõµÄÒ³Ãæ»º´æ£¬Í¨³£ÓÐÈçÏÂÁ½ÖÖÓ¦Ó÷½Ê½£º
¡¡¡¡Ò»¡¢»ùÓÚÊý¾Ý¿â´¥·¢(ÉèÖûº´æÒÀÀµ²ßÂÔ£¬µ±Êý¾Ý¿âÖÐÊý¾Ý·¢Éú±ä»¯Ê±£¬´¥·¢»º´æÊ§Ð§;µ«Î¢ÈíÌṩµÄ½â¾ö·½°¸Ä¿Ç°½öÖ§³ÖSQL Server,Èç¹ûÊÇORACLEÐèÒª×Ô¼ºÊµÏÖ´¥·¢½Ó¿Ú)¡£
¡¡¡¡¶þ¡¢»ùÓÚÎļþÒÀÀµµÄ²ßÂÔ(¿ÉÒÔÉèÖûº´æÒÀÀµÓÚÎļþÖÐµÄ¾ß ......
ASP ÊÇÒ»Ïî΢Èí¹«Ë¾µÄ¼¼Êõ£¬ÊÇÒ»ÖÖʹǶÈëÍøÒ³ÖеĽű¾¿ÉÓÉÒòÌØÍø·þÎñÆ÷Ö´ÐеķþÎñÆ÷¶Ë½Å±¾¼¼Êõ¡£ Ö¸ Active Server Pages£¨¶¯Ì¬·þÎñÆ÷Ò³Ãæ£© £¬ÔËÐÐÓÚ IIS Ö®ÖеijÌÐò ¡£
IIS
¡¡¡¡IIS Ö¸ Internet Information Services£¨ÒòÌØÍøÐÅÏ¢·þÎñ£©
¡¡¡¡IIS ÊÇ Windows 2000 À¦°óµÄÃâ·Ñ×é¼þ
¡¡¡¡IISͬʱҲÊÇ Windows NT ......
9.3 ͨ¹ýPHP²Ù×÷AccessÊý¾Ý¿â
9.3.1 Á¬½ÓAccessÊý¾Ý¿â
ÔÚPHPÖÐÁ¬½ÓAccessÓÐÈçÏÂ3ÖÖ·½Ê½¡£
£¨1£©´´½¨ÏµÍ³Êý¾ÝÔ´£¬ÓÃPHPÌṩµÄODBCº¯Êý
¼´¿É¡£
£¨2£©Í¬Ñù¿ÉÒÔʹÓÃPHPµÄODBCº¯Êý£¬µ«²»´´½¨
Êý¾ÝÔ´¡£¿ª·ÅÊý¾Ý¿âÁ¬½Ó£¨Open DateBase
Conection£¬ODBC£©ÊÇWindows Open
Server£¨¿ª·Å·þÎñ£©API£¨WOSA£©²úÆ·Ö®Ò ......
ÔÚGlobal.asaxÖе¼ÈëÃüÃû¿Õ¼ä
<%@Global ...
<%@Import Namespace= "System.Data " %>
<%@Import& ......