which way is the best?

[Chris]

Hi,

I want to connect PHP pages to Access database. I saw there are at least to
ways:

$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) ;

What should i take? Are there significant differences?

Thanks
Chris

[Colin McKinnon]

Chris wrote:

Hi,

I want to connect PHP pages to Access database. I saw there are at least
to ways:
s/to/two
$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) ;

What should i take? Are there significant differences?

Both are rather slow. COM is tied to a MS-Windows architecture and therefore
limits portability. AdoDB will work with all sorts of DBMS. Personally I'd
go for ODBC ('cos I'm a speed freak - so I never use MS-Access anyway).

C.