Posted by Colin McKinnon on 09/27/05 12:17

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.

[Back to original message]