Posted by chris on 09/30/05 19:21

Hi,

I have already post this question but i still wonder which is the best
method for connecting Access with PHP. I know that Access is not the ideal
database, but for some reason i have to do with Access.
Are there advantages of some one?
Thanks

Chris

$connect = odbc_connect ('DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=d:\access\newres.mdb', '', '');

or
$conn = new COM('ADODB.Connection');
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=d:\access\newres.mdb");

or

include('../adodb/adodb.inc.php');
$dsn = 'Provider=Microsoft.Jet.OLEDB.4.0;'. 'Data
Source=d:\access\newres.mdb;';
$db = NewADOConnection('ado_access');
$db->PConnect($dsn);

[Back to original message]