Subject | PDO connection problems |
---|---|
Author | Robert martin |
Post date | 2009-06-14T22:04:57Z |
Hi
I am new to this group so excuse me if it has been covered many times (I
did a search but cant find much).
I have some PHP scripts that uses PDO as the database connection
method. I used PDO because of its multi database connection system. It
is working great at a number of sites using MYSQL but I am now trying to
use it with Firebird.
I have setup IIS and installed PHP / PDO / Firebird extension (PHP
5.3). PhpInfo shows everything is running. In my scripts I should be
able to change the connection string and it should be done, however my
connection string just wont work.
my connection script is as follows
$dbh = new
PDO("firebird:dbname=localhost:C:\\ReportDB\\reports.fdb", "SYSDBA",
"masterkey");
With this I get a 'HTTP/1.1 500 Internal Server Error'. I have tried it
without the double slashes and it no longer fails but returns NULL.
Actually I have tried just about everything I can think of and no go !!
Any help would be greatly appreciated :)
Thanks
Rob
--
/Robert Martin/
/Software development manager/
Chreos
www.chreos.co.nz
Ph +64 03 377-0495
I am new to this group so excuse me if it has been covered many times (I
did a search but cant find much).
I have some PHP scripts that uses PDO as the database connection
method. I used PDO because of its multi database connection system. It
is working great at a number of sites using MYSQL but I am now trying to
use it with Firebird.
I have setup IIS and installed PHP / PDO / Firebird extension (PHP
5.3). PhpInfo shows everything is running. In my scripts I should be
able to change the connection string and it should be done, however my
connection string just wont work.
my connection script is as follows
$dbh = new
PDO("firebird:dbname=localhost:C:\\ReportDB\\reports.fdb", "SYSDBA",
"masterkey");
With this I get a 'HTTP/1.1 500 Internal Server Error'. I have tried it
without the double slashes and it no longer fails but returns NULL.
Actually I have tried just about everything I can think of and no go !!
Any help would be greatly appreciated :)
Thanks
Rob
--
/Robert Martin/
/Software development manager/
Chreos
www.chreos.co.nz
Ph +64 03 377-0495