which method is the best

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • chris

    which method is the best

    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={Micro soft Access Driver
    (*.mdb)};DBQ=d: \access\newres. mdb', '', '');

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

    or

    include('../adodb/adodb.inc.php') ;
    $dsn = 'Provider=Micro soft.Jet.OLEDB. 4.0;'. 'Data
    Source=d:\acces s\newres.mdb;';
    $db = NewADOConnectio n('ado_access') ;
    $db->PConnect($dsn) ;



Working...