ʹÓÃ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
Ïà¹ØÎĵµ£º
using System;
using System.Data;
using System.Data.OleDb;
namespace AccessDb
{
/**//// <summary>
/// AccessDb µÄժҪ˵Ã÷£¬ÒÔÏÂÐÅÏ¢ÇëÍêÕû±£Áô
/// ÇëÔÚÊý¾Ý´«µÝÍê±Ïºóµ÷ÓÃClose()·½·¨£¬¹Ø±ÕÊý¾ÝÁ´½Ó¡£
/// </summary>
public class AccessDbClass
{
±äÁ¿Éù ......
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.spri ......
À¶ÑÀ»µµôÁË£¬ÕâÑùÒ»À´ ÊÖ»ú°²×°³ÌÐò±äµÃºÜ²»·½±ãÁË¡£Ò»¿ªÊ¼ÊÇÏȰÑÒª°²×°µÄ³ÌÐòÒÔ¸½¼þµÄÐÎʽ·¢µ½ÓÊÏä ÔÙÔÚÊÖ»úÉÏÅäÖÃÓÊÏä ÈúóÏÂÔØ¸½¼þ°²×°£¬ÕâÑùËäÈ»½â¾öÁËÎÊÌâ µ«ÊÇ»¹ÊÇÓкܶ಻·½±ãµÄµØ·½¡£ ÓÚÊÇ ×Ô¼ºÏë´î½¨Ò»¸ö·þÎñÆ÷ Ö±½ÓʵÏÖÔÚÏß°²×°¡£Ç°ÌáÊÇÊÖ»úÖ§³Öwifi£¬¾ÍÊÇ˵ÐèÒªÊÖ»ú·ÃÎÊÄÚÍøµØÖ·£¬·ñÔòµÃ»° ¾Í±È½Ï ......
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£©²úÆ·Ö®Ò ......