|
|
Posted by Jochem Maas on 10/21/07 11:22
James wrote:
> How do you specify a port to connect to? I tried using localhost:3050
you can't/don't specify the port in your connection string.
> (3050 is the default port that Firebird) and that didn't work.
yeah somebody using the firebird extension! or trying at least. ;-)
you have to specify the port that firebird is bound to in the SERVICES
file (its name and location differ depending on your platform) -
on windows the firebird installer should do this for you.
on linux you have to edit /etc/services (the format is
pretty simple)
also check out the aliases.conf file which lives alongside your
fierbird.conf file where you can do stuff like:
mydb = '/path/to/your.gdb'
and then:
ibase_connect ( 'mydb', $username , $password );
which is nice and allows easy to port code :-)
>
>
> $host = 'localhost:/path/to/your.gdb' ;
IIRC the localhost part is not required, so the following will do:
$host = '/path/to/your.gdb'
by all means come back with firebird questions - as far as firebird/php
are concerning I am a 1 man [marketing] army :-)
computed-fields, multi-db transactions, views, triggers, constraints, stored procedures,
PROPER parameterized queries!
it's like using Oracle without the pre-requisite second mortgage, without the
the nightmare API AND (maybe most important) with the added bonus that you are not making some
twat like Larry Elison even richer :-)
for those of you who are strong in DBs/SQL give it a try it's great stuff!
> $username = 'SYSDBA';
> $password = 'masterkey';
do change this :-) and/or lock down port 3050 on your firewall.
rgds
>
> $dbh = ibase_connect ( $host , $username , $password );
Navigation:
[Reply to this message]
|