php ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=$access;";
// $dsn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=$access;";
$db->Connect($dsn) or
die("Connect({$dsn}) Fail!\r\n$db->ErrorMsg()");
?>
ÈçºÎÓÃÕâÁ½ÖÖÁ¬½Ó×Ö·û´®,ÈóÌÐòÅÜÆðÀ´
$dsn = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=$access;";
// $dsn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=$access;";
ÁíÍâ,ÇëÎÊ´øÃÜÂëµÄÁ¬½Ó ÓÃÕâÁ½ÖÖÁ¬½Ó ÈçºÎʵÏÖ?
СµÜÀ§ÈÅÁ˺þÃÁË,Çë¸÷λǰ±²ÃDz»ÁߴͽÌ,Ö¸µãÃÔ½ò!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Ê®·Ö¸Ðл!!!!!!!!!!!
ÒÔǰдµÄ PHPÁ¬½ÓAccessÊý¾Ý¿âÎÞ´í°æ
http://blog.csdn.net/brothercat/archive/2006/07/21/952716.aspx
Èç¹û¼ÓÉÏÃÜÂ룬
½«
$connStr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("easy.mdb");
¸Ä³É
$connStr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("easy.mdb").";Database Password=123";
ÊÔÊÔ£¬123±íʾÃÜÂë×Ö·û´®
»¹ÊÇÄǾäÀÏ»°,½¨ÒéʹÓÃPDOÈ¥Á¬½Ó...
http://cn2.php.net/manual/en/ref.pdo-dblib.php#86668
Ïà¹ØÎÊ´ð£º
ÎÒÓÃPHPÀ©Õ¹Cʱ£¬ÓõÄÊÇÔ´ÂëextĿ¼ÏµÄ./ext_skel
×îºó±àÒë×ÜÊDz»ÄÜÉú³ÉÀ©Õ¹Ä£¿éµÄ.so¶¯Ì¬¿â£¬ÎÒÓõİ汾ÊÇ5.3.0£¬
ÕâÊÇÔõô»ØÊ£¬¸ßÊÖ½â´ðÏÂ
²»ÄÜÉú³ÉʱÓÐɶÌáʾÐÅÏ¢£¿
ÔËÐÐÁË/ext_skel --extname=Ä ......
ÓôÃÆÀ²£¬Õû¸öÎļþ¼ÐµÄÊôÐÔÎÒÒ²ÉèÖóÉ777ÁË,¾ÍÊDz»ÐС£
ÔÚÁíÍâһ̨linux·þÎñÆ÷ÉϽøÐÐͬÑùµÄ²Ù×÷£¬È´¿ÉÒÔÖ´ÐС£ ±ÈÈç ÔÚÏß½âѹ£¬¶¼³É¹¦ÁË¡£
µ«ÊÇÔÚÕą̂»úÆ÷ÉÏ£¬ËÀ»î¶¼²»ÐУ¬×ÜÊÇ permission denied...ÔÎ ......
ÎÒÃÇÁ¥ÊôÖпÆÔº¼ÆËãËùÍøÂçÖصãʵÑéÊÒ(http://www.ict.ac.cn/survey/channel/detail443.asp)»ù´¡ÉèÊ©¿ÎÌâ×é.
ÏÖÒòÏîÄ¿ºÍÒµÎñÍØÕ¹µÄÐèÒª,ÌØÐèÒªÕÐƸÓëÏîÄ¿Ïà¹ØµÄÍøÂçÓ¦Óù¤³Ìʦ1-2Ãû¡£
¾ßÌåÒªÇóÈçÏ¡£ÓÐÒâÕß ......
³ÌÐòʱASP+access
sql="select top 2 id,username from comp order by rnd(id) "
ÉÏÃæÓï¾äˢкó¶¼ÊÇÒ»¸öÖµ ÕâÑù»¹ÓÐËæ»úµÄÒâÒåÂð
ACCESSÓÐË¢ÐÂËæ»úÑ¡ÔñµÄSQLÓ ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......