ÎÒ¿´ÁËÄÇÆª¡¶ÔõÑùÔÚPHPÖÐͨ¹ýADOµ÷ÓÃAsscessÊý¾Ý¿âºÍCOM³ÌÐò¡·ÎÄÕºó£¬ÂíÉÏ×÷Á˲âÊÔ£¬½á¹ûʧ°ÜÁË¡£ÉËÐÄÊDz»ÊÇ¡£
Ôõô°ì£¿ÎÒÖ»ºÃÈ¥PHP¹Ù·½ÍøÕ¾ÇóÖú£¬»ÊÌì²»¸ºÓÐÐÄÈË£¬ÖÕÓÚÎÒÕÒµ½Á˴𰸡ª¡ª
¾ßÌåµÄ½â¾ö·½·¨ÈçÏ£º
£¨1£©½øÈëhttp://php.weblogs.com/adodb£¬ÏÂÔØÏàÓ¦µÄZIP°ü£»Í¬MICROSOFT¹«Ë¾µÄADOÒ»Ñù£¬¸Ã¶«¶«ÓÃPHPʵÏÖADOͬ¸÷ÖÖ¸÷ÑùÊý¾Ý¿â´ò½»µÀ£¨Ì«ºÃÁË£¬ËùÓÐÀàÐ͵ÄÊý¾Ý¿â¶¼ÄÜ´¦Àí£©¡£
£¨2£©½â°ü£¬ÀïÃæÎļþºÜ¶à£¬²»¹ýÓÐÓõÄÖ»ÓÐohtml.inc.phpºÍadodb.inc.php£¬°ÑËüÃǸ´ÖƵ½ÏàӦĿ¼Ï£¨»òÊǰ²×°php4µÄȱʡĿ¼ÏÂc:\php4\peer\£¬»òÊǵ±Ç°ÔËÐгÌÐòĿ¼Ï£¬ÊÓinclude()º¯Êý¶ø¶¨£©£»
£¨3£©È»ºóÔÚ±¾¼¦£¨´íÎó×ÖÒ»¸ö£¬ÊÇ»ú£©µÄc:\myphpĿ¼ÏÂ(iisÏÂÉèÖÃͨ¹ýhttp://localhost/jhkÀ´·ÃÎÊ)£¬ÔìÁËÒ»¸öÃûΪtest.mdbµÄaccess¿â£¬ÀïÍ·ÔÙÔì¸öexpertsµÄ±í¡¡¡£ÎªÁËͨ¹ýDSNÀ´·ÃÎÊ£¬ÎҰѸղŵÄACCESS¿âÔÚDSNÖÐÈ¡Ãûtest¡£
£¨4£©ÔËÐС£¿´×Å˵Ã÷ÊéÎÒÔìÁËÕâô¸ö³ÌÐò£º
dbtest.php£¬ÄÚÈÝÈçÏ£º
include('tohtml.inc.php'); // load code common to ADODB
include('adodb.inc.php'); // load code common to ADODB
$conn = &ADONewConnection('access'); // create a connection
$conn->PConnect('test');// connect to MySQL, agora db
$sql = 'select name, group1 from experts';
$rs = $conn->Execute($sql);
rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID'));
$rs->Close(); // optional
$conn->Close(); // optional
?>
È»ºó£¬IEÖдòÈ룺http://localhost/jhk/dbtest.php
°¦£¡½á¹û³öÀ´ÁË¡£ ÁîÈË»ù±¾ÂúÒ⣡£¡
£¨5£© ½Ó×Å£¬ÎÒÓÖÏ룺»¹ÒªÉèÖÃDSN£¬·³²»·³£¡ÈƹýDSNÓ¦ÈçºÎ½â¾ö£¿ÒòΪÔÚaspÖУ¬ÎÒϰ¹ßÓÃconn.open("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("../nydatabase.mdb"))À´´¦Àímdb¿â£¬ÄÇËÙ¶È¿ìѽ£¡
£¿¡¡ÏëÁËÓÖÏ룬¿´ÁËÓÖ¿´¡¡¡£
ÕÒÕÒÕÒ£¬¡¡£¬ºÙºÙ£¬ÖÕÓÚÔÚtestdatabases.inc.php ÖÐÕÒµ½Á˴𰸣¡ ÎÒÔٰѸղŵijÌÐò¸Ä±à£º
include('tohtml.inc.php'); // load code common to ADODB
include('adodb.inc.php'); // load code common to ADODB
$db = &ADONewConnection("ado_access");
print "
Connecting $db->databaseType...
";$access = 'test.mdb';
$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='. $access . ';';.'USER ID=;PASSWORD=;';
if (@$db->PConnect($myDSN, "", "", "")) {
print "ADO version=".$db->_connectionID->version."
";
$sql = 'select name, group1 from experts';
$rs = $db->Execute($sql);
rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID'));
} else print "ERROR: Access test requires a Access database $access".'
'.$db->ErrorMsg();
?>
ÔËÐС£
Ò»Çи㶨£¡

