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.È»ºóµ¥»÷È·¶¨,²¢¹Ø±Õ×é¼þ·þÎñ.
Ïà¹ØÎĵµ£º
ºÜÔçÇ°¾ÍÏë×öÎļþµÄ½âѹ¡¢Ñ¹Ëõ¡¢ÏÂÔØ
ÁË£¬²»¹ýһֱûʱ¼ä£¬ÏÖÔÚÏîÄ¿×öÍêÁË£¬½ñÌìŪÁËÏ¡£²»¹ý½âѹ£¬Ñ¹ËõµÄ·½·¨»¹ÊÇ¿´µÄÍøÉϵģ¬ÎûÎû~~²»¹ýÎÒ°ÑËüÃÇ×ÛºÏÁËÒ»ÏÂŶ¡£ºÇºÇ~~
1.ÏÈÒª´ÓÍøÉÏÏÂÔØÒ»¸öicsharpcode.sharpziplib.dll
2.½¨Á¢ÀàAttachmentUnZip£¬ÄÚÈÝÈçÏ£º
using System;
using System.Data;
using System.Config ......
ÒýÓÃusing System.Web.UI.HtmlControls;
ǰ̨µÄ<table id="mytab" border="1" runat="server" class="t1" width="600">
......
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using AlltripDLL;
public pa ......
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& ......