Re: php/osx and firebird
| From: | James | Date: | Wed, 15 Jun 2005 18:15:31 +0000 |
| Subject: | Re: php/osx and firebird | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-217022@lists.php.net to get a copy of this message | ||
Here's the answer!
http://community.borland.com/article/0,1410,25290,00.html
I updated the SERVICE file on my Apache/PHP machine and all is well.
At 12:04 PM -0400 6/15/05, James wrote:
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-- -James