Re: Re: How to Connect remote DB server?

Couldn't be ! I have MS client connecting to the db-server! I tried odbc_connect for both MSSQL & PostgreSQL and it is ok! However, odbc connection is no good for db processing! Further help? ./pl "Niklas lampén" <niklas.lists@publico.fi> wrote in message news:00bb01c2e895$5289f820$ba93c5c3@Niklas... Possibly the db-server is accepting only localhost connections. Niklas -----Original Message----- From: Patrick LOK [mailto:patricklok@msn.com] Sent: 12. maaliskuuta 2003 14:39 To: php-db@lists.php.net; php-general@lists.php.net Subject: [PHP] Re: [PHP-DB] How to Connect remote DB server? 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? > */ > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ########################################### This message has been scanned by F-Secure Anti-Virus for Internet Mail. For more information, connect to http://www.F-Secure.com/ ########################################### This message has been scanned by F-Secure Anti-Virus for Internet Mail. For more information, connect to http://www.F-Secure.com/