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.È»ºóµ¥»÷È·¶¨,²¢¹Ø±Õ×é¼þ·þÎñ.
Ïà¹ØÎĵµ£º
Æäʵ¶ÔÕâ·½ÃæÒ»Ö±ÕÆÎյIJ»¹»ÊìÁ·£¬ÊôÓÚ°ëͰˮÄÇÖÖÀàÐÍ—Ò»Öª°ë½â£¬ËùÒÔÕâ´ÎÖØÐÂÕâÔĶÁÁË¡¶asp.net 2.0¼¼ÊõÄÚÄ»¡·¶ÔÕâ¿é֪ʶÓÖÓÐÁËеÄÈÏʶ¡£
¡¡¡¡ÔÚ»ùÓÚIISµÄWeb·þÎñÆ÷ÉÏ¿ÉÒÔ·ÃÎʵÄËùÓÐ×ÊÔ´°´ÎļþÀ©Õ¹Ãû½øÐзÖ×顣Ȼºó°ÑÈκÎÒ»¸öÊäÈëµÄÇëÇó·ÖÅä¸øÌØ¶¨µÄÔËÐÐʱģ¿é´¦Àí¡£ISAPI(Internet Server Application Programmin ......
ÒýÓÃusing System.Web.UI.HtmlControls;
ǰ̨µÄ<table id="mytab" border="1" runat="server" class="t1" width="600">
......
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£©²úÆ·Ö®Ò ......
foreach(Control con in this.Controls[1].Controls)
{
if(con is TextBox)
{
((TextBox)con).Text="";
}
}//Õâ¶Î´úÂëÖ´Ðгɹ¦£¬µ«ÎÒ²»Ã÷°×ÕâÀïµÄ1´úÂëʲô£¿
µ«ÊÇ» ......