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

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

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.