Subject Re: [firebird-php] Firebird PHP-PDO functions
Author Lester Caine
salbefe wrote:

> Hi all,
>
> I'm trying to connect to a Firebird database using the PHP-PDO
> functions but I'cant.
>
> The problem is the dns that is used to connecto to.
>
>
> At PHP.NET there is an example of how to use the firebird driver with
> PDO:
> firebird:User=john;Password=mypass;Database=DATABASE.GDE;DataSource=lo
> calhost;Port=3050
>
>
> If my database is in c:\databases\test.gdb, what should I write to
> connect to the database?
>
> I've tried :
>
> 'firebird:User=SYSDBA;Password=masterkey;Database=c:\databases\test.gd
> b;DataSource=localhost;Port=3050';
>
> and other connections string and It does not work.

salbefe - The Firebird PDO driver has not been kept in line with the
current versions of PDO (In fact I don't think there IS a current build
of it :( ) - basically no-one has the time to work on it, and since you
loose much of the Firebird capabilities when switching to PDO, you end
up having to make a php_interbase connection as well. So are all still
on the native driver ;)

ADOdb provides an better abstraction layer - while PDO simply makes the
function names the same, but does nothing to allow SQL from one engine
to work with another.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.