php/osx and firebird
| From: | James | Date: | Wed, 15 Jun 2005 16:04:29 +0000 |
| Subject: | php/osx and firebird | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-217012@lists.php.net to get a copy of this message | ||
I have a windows machine with Firebird and the default database.
I've configured another machine with Apache and PHP. I want to write PHP scripts to remotely access the Firebird database.
I followed the instructions at:
http://us3.php.net/ibase
I changed the php.ini to enable the php_interbase.dll and the php_gd2.dll by commenting out the two lines under Windows Extensions
I also copied gds32.dll from the php directory to the C:\windows\system32 directory.
I restarted Apache.
This is in my PHP script:
"
$host = "10.1.4.58:c:\fbwin50\fbdata\fbdata.fdb";
$username = "SYSDBA"; $password = "masterkey";
$dbh = ibase_pconnect ($host, $username, $password);
$stmt = "SELECT * FROM EVENTTYP";
$sth = ibase_query ($dbh, $stmt);
I get the following error:
Warning: ibase_pconnect() [function.ibase-pconnect]: Unable to complete network request to host "10.1.4.58". Failed to locate host machine. Undefined service gds_db/tcp. in d:\htdocs\Website\PHP\dtest.php on line 17
Warning: ibase_query() [function.ibase-query]: invalid database handle (no active connection) in d:\htdocs\Website\PHP\dtest.php on line 20
"
I was able to use isql to remotely connect using the parameters above.
What am I not doing on the PHP end to get this to work?
--
-James