accessÊý¾Ý¿â²åÈë¸üгö´í
½ñÌì̸Á½¸öASPÔËÐÐʱ¿ÉÄܳöÏÖµÄÓëIISÓйصĴíÎó
-------------------------------------------------------------------
´íÎóÀàÐÍÒ»£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²»ÄܸüС£Êý¾Ý¿â»ò¶ÔÏóΪֻ¶Á¡£
´íÎóÀàÐͶþ£º
Microsoft OLE DB Provider for ODBC Drivers ´íÎó ''80004005''
[Microsoft][ODBC Microsoft Access Driver]³£¼û´íÎó ²»ÄÜ´ò¿ª×¢²á±í¹Ø¼ü×Ö ''Temporary (volatile) Jet DSN for process 0x728 Thread 0x854 DBC 0x276fb44 Jet''¡£
-------------------------------------------------------------------
µ±ÄãʹÓÃASPÁ¬½ÓÊý¾Ý¿âʱ¿ÉÄÜ»á³öÏÖÕâÖÖÇé¿ö£¬ÎªÊ²Ã´ÄØ£¿ÒòΪÄúÊý¾Ý¿âÎļþËùÔÚµÄĿ¼ȨÏÞ¶ÔÌØ¶¨µÄÓû§Ã»ÓпªÆô×ã¹»µÄȨÏÞ£¬ÄãÖ»ÄܽøÐÐÖ»¶Á·ÃÎÊ£¬Ò»°ã³öÏÖÕâÖÖÇé¿öµÄÎļþϵͳΪNTFS£¬ÄÇÔõô½â¾öÄØ£¿
Ê×ÏÈ£¬ÄãÕÒµ½Êý¾Ý¿âËùÔÚĿ¼£¬Ò²¿ÉÒÔÊÇÉϲãĿ¼£¬È»ºóÉèÖÃÎļþ¼Ð °²È« ÊôÐÔ£¬×î¼òµ¥µÄÊǰÑeveryoneµÄȨÏÞÉèÖóÉÍêÈ«¼´¿É£¬ÄǶÔÓÚÕâ¸öÎÊÌ⣬Ӧ¸ÃʹÄĸö¶ÔÏóµÄȨÏÞÉèÖóÉÍêÈ«ÄØ£¿´ð°¸ÊÇ IUSER_ÄúµÄ»úÆ÷Ãû ¡£Õâ¸öÊÇÄĸö¶ÔÏó£¿Õâ¸öÊÇInternetÀ´±öÓû§£¬ÓÐÐËȤµÄ¶ÁÕß¿ÉÒÔ²éÔÄÏà¹Ø×ÊÁÏ¡£ÖÁ´Ë£¬ÎÊÌâ½â¾ö£¬Äã¿ÉÒÔÔÙÔËÐÐһϿ´¿´ÊÇ·ñ½â¾öÁËÎÊÌâ¡£
¸½£º¶ÔÓÚWindows XPµÄÓû§£¬Ò²ÐíÄã»áãȻÓÚ¸ü¸ÄÎļþ¼ÐµÄ°²È«ÊôÐÔ¡£ÒòΪÔÚĬÈÏÇé¿öÏ£¬Windows XPʹÓÃÁ˼òµ¥Îļþ¹²Ïí·½·¨£¬ËùÒÔ£¬µ±Äãµã ÊôÐÔ µÄʱºòÊÇ¿´²»µ½ °²È« Ñ¡ÏµÄ¡£¾ßÌå²Ù×÷ÈçÏ£º
ÎҵĵçÄÔ-->Îļþ¼ÐÑ¡Ïî-->²é¿´-->È¡Ïû ʹÓüòµ¥Îļþ¹²Ïí£¨ÍÆ¼ö£© µÄ¹´Ñ¡ ¼´¿É¡£Äã²é¿´Ò»ÏÂÄãÒª¸ü¸ÄÎļþ¼ÐµÄÊôÐÔ£¬ÊDz»ÊǶàÁËÒ»¸ö °²È« Ñ¡Ïî¿¨ÄØ£¿
Ïà¹ØÎĵµ£º
×òÍíÔÚ×öAccessÊý¾Ý¿â¿ª·¢Ê±Óöµ½Ò»¸ö¼òµ¥µÄÄ£ºý²éѯÎÊÌ⣬ÔÚaccess2007ÀïÃæ¿ÉÒÔ²é³öÀ´£¬µ«ÓÃC#2.0²éѯ¾ÍÊDz鲻³öÀ´¡£
ºóÀ´ÊÔ³öÀ´ÁË£¬ÔÀ´ ÊÇjetÓï·¨µÄÎÊÌ⣺
ÔÚAccessÖУ¬Ä£ºý²éѯÓà * ºÅ£¬Èç select * from T_PO where po_NO like '*8*'
µ«ÔÚC#³ÌÐòÀïÃæÐ´µÄʱºòÒªÓà % ºÅ£¬¼´ select * from T_PO where po_NO like '%8% ......
±¾À´¿¼ÂÇÓÃXMLÎļþÀ´´æÊý¾ÝÊÇÒòΪÆä¿çƽ̨ÐÔ£¬¶øÇÒ²»Óð²×°Ìض¨µÄÈí¼þ¡£µ«¾¹ýÑо¿ÁËÒ»Õó×Ó·¢ÏÖ£¬XMLÓÃÓÚ´æ·ÅÉÙÊý¾ÝÊÇ¿ÉÒÔ£¬µ«´æ·Å´óÖÐÐÍÊý¾Ý¾ÍÏԵúܳÔÁ¦£¬»³ÒÉҲûÓÐÈË»áÕâô×ö¡£¶øÈç¹û²ÉÓÃSQL SERVER´æÊý¾Ý£¬ÓÖÏԵñȽÏÇü²Å£¬±Ï¾¹ÎÒ×öµÄÖ»ÊÇÑо¿¿Í»§¶ËµÄÒ»¸öС³ÌÐò£¬ÅäÖôú¼ÛҲ̫´óÁË¡£»ùÓÚÕâÁ½ÕßÖ®¼ä£¬»¹ÊǾö¶¨Ñ ......
JDBCÁ¬½ÓMySQL
¼ÓÔØ¼°×¢²áJDBCÇý¶¯³ÌÐò
Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
JDBC URL ¶¨ÒåÇý¶¯³ÌÐòÓëÊý¾ÝÔ´Ö®¼äµÄÁ¬½Ó
±ê×¼Óï·¨£º
<protocol£¨Ö÷ҪͨѶÐÒ飩>:<subprotocol£¨´ÎҪͨѶÐÒ飬¼´Çý¶¯³ÌÐòÃû³Æ£©>:<da ......
ASP.NETÈçºÎÁ¬½ÓAccess»òSQL ServerÊý¾Ý¿â
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+ ......
http://www.tongyi.net/article/20031101/200311013786.shtml
ËùνµÄÊý¾Ý´«Ê䣬ÆäʵÊÇÖ¸SQLServer·ÃÎÊAccess¡¢Excel¼äµÄÊý¾Ý¡£
ΪʲôҪ¿¼Âǵ½Õâ¸öÎÊÌâÄØ£¿
ÓÉÓÚÀúÊ·µÄÔÒò£¬¿Í»§ÒÔǰµÄÊý¾ÝºÜ¶à¶¼ÊÇÔÚ´æÈëÔÚÎı¾Êý¾Ý¿âÖУ¬ÈçAcess¡¢Excel¡¢Foxpro¡£ÏÖÔÚϵͳÉý¼¶¼°Êý¾Ý¿â·þÎñÆ÷ÈçSQLServer¡¢ORACLEºó£¬¾³£ÐèÒª·ÃÎÊÎı¾Êý ......