ʹÓÃaspÁ¬½Óaccess2007×¢ÒâÊÂÏî
ǰ¼¸ÌìÔÚ×Ô¼ºµÄ±Ê¼Ç±¾Éϰ²×°ÁËOFFICE2007¡£½ñÌì×öÁËÒ»¸ö°Ù¶ÈÓÑÇéÁ´½Ó¼ì²éµÄ¹¤¾ß£¬ ÔÚÁ¬½ÓACCESS2007Êý¾Ý¿âµÄʱºò£¬Ê¹ÓõÄÇý¶¯´úÂëΪ£º"provider=microsoft.jet.oledb.4.0;data source="&server.mappath("queryrecord.mdb") ¡£È··¢ÏÖÌáʾ£º
Microsoft JET Database Engine ´íÎó ''80004005''
²»¿Éʶ±ðµÄÊý¾Ý¿â¸ñʽ
µ«ÊÇÒÔǰûװOFFICE2007ǰ½¨Á¢ºÃµÄÊý¾Ý¿â£¨ÒÔǰÓõÄACCESS2003£©£¬Ê¹ÓÃÕâ¸ö´úÂë¿ÉÒÔÕý³£ÔËÐС£ÏëÁËÒ»Ï룬¹À¼ÆÊÇÒòΪACCESS2007µÄÇý¶¯´úÂëÒѾ·¢Éú±ä»¯¡£½øÈëhttp://www.connectionstrings.com/£¨×¢Ò⣺¸ÃÍøÕ¾ÌṩÁËÏÖÓÐËùÓÐÊý¾Ý¿âµÄÁ¬½Ó·½Ê½£¬½¨Òé´ó¼ÒÊղظÃÍøÖ·£©Ò»¿´£¬¹ûÕæACCESS2007µÄÊý¾Ý¿âÁ¬½Ó·½Ê½ÒѾ·¢Éú±ä»¯¡£ÒѾ¸ü¸ÄΪ£º
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;
ÓÚÊǸü¸ÄÁËÏ´úÂ룬³ÌÐòÔËÐÐÕý³£¡£
Ëæºó½«´úÂë¸üÐÂÖÁ·þÎñÆ÷http://baiduquery.newbooks.com.cn ,È··¢ÏÖ³ÌÐò»¹ÊDz»ÄÜÔËÐУ¬Ìáʾ“Çý¶¯Ã»Óа²×°”£¬ÓÚÊǰÑÇý¶¯´úÂë¸ü¸ÄΪmicrosoft.jet.oledb.4.0£¬Ìáʾ“²»¿Éʶ±ðµÄÊý¾Ý¿â¸ñʽ”£¬¿´À´ÔÚ±¾»ú½¨Á¢µÄÊý¾Ý¿âΪACCESS2007µÄ»°£¬´«µ½·þÎñÆ÷ÉÏÈÔ¾ÉΪACCESS2007¡£ÓÚÊÇÍøÉÏËÑË÷ÁËÒ»ÏÂACCESS2007µÄÇý¶¯£¬°²×°£¬³ÌÐòÔËÐÐÕý³£¡£
ACCESS2007µÄÇý¶¯ÏÂÔØµØÖ·£ºhttp://www.microsoft.com/downloads/details.aspx?FamilyID=7554f536-8c28-4598-9b72-ef94e038c891&DisplayLang=zh-cn
Ïà¹ØÎĵµ£º
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£©²úÆ·Ö®Ò ......
ASPÓëÊý¾Ý¿âÓ¦ÓÃ(¸ø³õѧÕß)
--------------------
¼û×î½üÐí¶àÍøÓÑѯÎÊһЩ¹ØÓÚÊý¾Ý¿â²Ù×÷µÄ»ù´¡ÎÊÌ⣬ÏÖ°ÑÎÒÒÔǰдµÄһƪ¼òµ¥½Ì³ÌÌùÉÏÀ´£¬ºÃÈÃһЩ³õѧÕß×î¿ìµÄÈëÃÅ£º
ASPÓëÊý¾Ý¿âÓ¦Ó㨸ø³õѧÕߣ©
Ò»°ãÀ´Ëµ£¬Ò»¸öÕæÕýµÄ¡¢ÍêÕûµÄÕ¾µãÊÇÀë²»¿ªÊý¾Ý¿âµÄ£¬ÒòΪʵ¼ÊÓ¦ÓÃÖУ¬ÐèÒª±£´æµÄÊý¾ÝºÜ¶à£¬¶øÇÒÕâЩÊý¾ÝÖ®¼äÍùÍù»¹ ......
<%@ Language=VBScript %>
<SCRIPT id=DebugDirectives runat=server language=javascript>
// Set these to true to enable debugging or tracing
@set @debug=false
@set @trace=false
</SCRIPT>
<HTML>
<HEAD>
<META name=VI60_defaultClientScript content=VBScript>
< ......
×î½ü×öÁËÒ»¸öÊý¾ÝÕï¶ÏµÄÏîÄ¿£¬ÀïÃæ×Ô¼ºÐ´ÁËÒ»¸öÊý¾Ý¿âµÄ²Ù×÷À࣬°üº¬£ºÁ¬½ÓÊý¾Ý¿â¡¢¶ÁÊý¾Ý±í¡¢Ö´ÐÐSQL²Ù×÷£¬ÊÍ·ÅÊý¾Ý¿âµÈ×é³É£¬Ï£Íû¶Ô´ó¼ÒÓÐÓã¬ÓÉÓÚˮƽÓÐÏÞ£¬ÈôÓдíÎó»òÕß´úÂë²»×ãµØ·½»¶ÓÖ¸Õý£¬Ð»Ð»¡£
ADOOperate.H
//////////////////////////////////////////////////////////////////////
// ......