[PHP-DB] How to Connect remote DB server?
It is possible to connect a remote db server using x_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" Can anyone help? regards ./pl
Re: [PHP-DB] How to Connect remote DB server?
On Wednesday 12 March 2003 19:28, Patrick LOK wrote: > It is possible to connect a remote db server using x_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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Wednesday 12 March 2003 19:28, Patrick LOK wrote: > > It is possible to connect a remote db server using x_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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to Connect remote DB server?
A couple of things. First, I believe it's pg_connect(), not pgsql_connect(). Also, note that according to the docs, the old syntax with multiple parameters $conn = pg_connect("host", "port", "options", "tty", "dbname") has been deprecated. But more importantly, can you ping the postgres/mssql server from the web server? Can you connect to them via the command line or via ODBC? Try to narrow it down to the network, PHP, or your code. --- Patrick LOK <[EMAIL PROTECTED]> wrote: > 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" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > On Wednesday 12 March 2003 19:28, Patrick LOK wrote: > > > It is possible to connect a remote db server using > x_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 Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > = Mark Weinstock [EMAIL PROTECTED] *** You can't demand something as a "right" unless you are willing to fight to death to defend everyone else's right to the same thing. *** __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] Re: [PHP-DB] 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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Possibly the db-server is accepting only localhost connections. Niklas -Original Message- From: Patrick LOK [mailto:[EMAIL PROTECTED] Sent: 12. maaliskuuta 2003 14:39 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Wednesday 12 March 2003 19:28, Patrick LOK wrote: > > It is possible to connect a remote db server using x_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/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php