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.NETÓÃURL´«µÝÖÐÎIJÎÊýÒ»°ã»áʧ°Ü£¬ÔÒòÊÇÔÚ»ñÈ¡²ÎÊýÖ®ºó½øÐÐÁ˱àÒëת»»¡£
¿ÉÄܹýÐÞ¸Äweb.configÎļþÈÃURLÕý³£´«µÝÖÐÎIJÎÊý
ÔÚSystem.web½ÚÌí¼Ó
<globalization requestEncoding="gb2312" responseEncoding="gb2312" culture="zh-CN" fileEncoding="gb2312"/>
¼´¿É ......
×î½ü×öÁËÒ»¸öÊý¾ÝÕï¶ÏµÄÏîÄ¿£¬ÀïÃæ×Ô¼ºÐ´ÁËÒ»¸öÊý¾Ý¿âµÄ²Ù×÷À࣬°üº¬£ºÁ¬½ÓÊý¾Ý¿â¡¢¶ÁÊý¾Ý±í¡¢Ö´ÐÐSQL²Ù×÷£¬ÊÍ·ÅÊý¾Ý¿âµÈ×é³É£¬Ï£Íû¶Ô´ó¼ÒÓÐÓã¬ÓÉÓÚˮƽÓÐÏÞ£¬ÈôÓдíÎó»òÕß´úÂë²»×ãµØ·½»¶ÓÖ¸Õý£¬Ð»Ð»¡£
ADOOperate.H
//////////////////////////////////////////////////////////////////////
// ......