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.È»ºóµ¥»÷È·¶¨,²¢¹Ø±Õ×é¼þ·þÎñ.
Ïà¹ØÎĵµ£º
ÓкܾÃÒ»¶Îʱ¼äÎÒµÄBLOGÉÏûÓгöÏÖAJAXÏà¹ØÑ¶Ï¢ÁË£¬Ö÷Òªµ±È»ÊÇÒòΪ¾ø´ó²¿·ÖµÄÖØÐͼ·Åµ½ÁËSilverlightÉíÉÏ(¿ÉÔ¤ÆÚµÄδÀ´Ó¦¸ÃÒ²»áÊÇÈç´Ë)¡£
µ«ÓÉÓÚ¹¤×÷ÉϵÄÐèÒª£¬×î½ü»¹ÊÇ»ØÍ·¿´ÁËһϼ´½«ÍƳöµÄASP.NET Ajax Library...£¬Ë³±ãÕÒÁËÒ»ÏÂÍøÂçÉϵÄѶϢ£¬¿´Õâ¸öÌ¬ÊÆÎÒ²ÂÏëÓ¦¸Ã²»ÉÙASP.NET¿ª·¢ÈËÔ±ºöÂÔµôÁËÕâ¸öÆäʵÒѾbet ......
1.Using jQuery with ASP
.NET
http://dotnetslackers.com/articles/ajax/using-jquery-with-asp-net.aspx
°üÀ¨jQueryÔõôµ÷ÓÃasp.net web service
2.jQuery and ASP.NET AJAX
UpdatePanel
http://www.dotnetfunda.com/articles/article471-jquery-and-aspnet-ajax-updatepanel.aspx
²¿·Ö¸üкóÔõô±£³ÖjQueryÓ¦Ó ......
1¡¢»ùÓÚASP.NET¼¼ÊõµÄÒ³Ãæ»º´æ
¡¡¡¡»ùÓÚASP.NET¼¼ÊõµÄÒ³Ãæ»º´æ£¬Í¨³£ÓÐÈçÏÂÁ½ÖÖÓ¦Ó÷½Ê½£º
¡¡¡¡Ò»¡¢»ùÓÚÊý¾Ý¿â´¥·¢(ÉèÖûº´æÒÀÀµ²ßÂÔ£¬µ±Êý¾Ý¿âÖÐÊý¾Ý·¢Éú±ä»¯Ê±£¬´¥·¢»º´æÊ§Ð§;µ«Î¢ÈíÌṩµÄ½â¾ö·½°¸Ä¿Ç°½öÖ§³ÖSQL Server,Èç¹ûÊÇORACLEÐèÒª×Ô¼ºÊµÏÖ´¥·¢½Ó¿Ú)¡£
¡¡¡¡¶þ¡¢»ùÓÚÎļþÒÀÀµµÄ²ßÂÔ(¿ÉÒÔÉèÖûº´æÒÀÀµÓÚÎļþÖÐµÄ¾ß ......
ÕâÀïÖ÷Ҫ̸̸ApplicationÀàÖеÄʼþ
ÓÉǰһƪÎÄÕ¿ÉÒÔÖªµÀ£¬Ò»µ©³öÏÖÁËHttpContextÀàµÄÒ»¸öʵÀý£¬HttpRuntimeÀà¾Í»á½¨Á¢Ò»¸öASP.NETÓ¦ÓóÌÐò¶ÔÏóÀ´Íê³É¸ÃÇëÇó¡£Ò»¸öÓ¦ÓóÌÐò°üÀ¨HttpApplicationÀàµÄÒ»¸öʵÀý¡£HttpApplicationÊÇÒ»¸öglobal.asaxÅÉÉúµÄ¶ÔÏ󣬴¦ÀíËùÓб»´«µÝ¸øÄ³¸öÐéÎļþ¼ÐµÃHttpÇëÇó¡£Ò»¸öÕýÔÚ ......
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£©²úÆ·Ö®Ò ......