Re: How to Connect remote DB server?
| From: | Jason Wong | Date: | Wed, 12 Mar 2003 12:30:53 +0000 |
| Subject: | Re: How to Connect remote DB server? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26274@lists.php.net to get a copy of this message | ||
On Wednesday 12 March 2003 19:28, Patrick LOK wrote:
> It is possible to connect a remote db server using xxxxx_connect?
> e.g. a PostgreSQL in server PSQLDB, ip=192.168.0.100 and a MSSQL server
> MSSQLDB, ip=192.168.0.110
>
> I tried pgsql_connect("psqldb","administrator","") &
> pgsql_connect("192.168.0.100","administrator","") but failed!
>
> Error is "Unable to connect to server: psqldb in psqltest.php on line 2" &
> "Unable to connect to server: 192.168.0.100 in psqltest.php on line 2"
Yes, it is possible to connect to a remote DB server. You have to make sure
that:
a) the DB server in question is configured to accept remote connections
b) any intervening firewall is correctly configured to allow DB traffic
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
Dr. Livingston?
Dr. Livingston I. Presume?
*/