Re: How to Connect remote DB server?
| From: | Patrick LOK | Date: | Wed, 12 Mar 2003 12:38:30 +0000 |
| Subject: | Re: How to Connect remote DB server? | ||
| References: | 1 2 | Groups: | php.db php.general |
| Request: | Send a blank email to php-general+get-139268@lists.php.net to get a copy of this message | ||
There is no firewall within the LAN environment.
I tried the mssql_connect too using mssql_connect("testdb","sa","")
but same
error returned!
Any idea?
./pl
"Jason Wong" <php-db@gremlins.biz> wrote in message
news:200303122030.53205.php-db@gremlins.biz...
> 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?
> */
>