note 91559 added to function.mssql-connect
| From: | IuriJacob at osu1 dot php dot net | Date: | Wed, 17 Jun 2009 04:36:54 +0000 |
| Subject: | note 91559 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-156951@lists.php.net to get a copy of this message | ||
Hi all!
I was trying to connect to a remote SQL2000 server (located on Internet, not on the local network),
then php always returned an "Unable to connect" error or something.
After waste a lot of time, by searching among foruns, blogs and logs, I finally discovered the
problem. I was monitoring the TCP connections between the server and my machine when I realized that
it wasn't been done. For some reason, my Apache 2.2 was "denying" php module from
doing remote connections.
So I changed the php configuration on apache to CGI mode rather than as module mode. Well, it worked
fine since that.
In despite of security holes that it involves, it was the only way I've found to make that
remote connection works between Apache2.2/PHP5 and MSSQL Server 2000.
Strangely, connections inside local network worked in any case (in CGI or module mode).
----
Server IP: 69.147.83.197
Probable Submitter: 187.21.24.176
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/91559
Del: integrated -- https://master.php.net/note/delete/91559/integrated
Del: useless -- https://master.php.net/note/delete/91559/useless
Del: bad code -- https://master.php.net/note/delete/91559/bad+code
Del: spam -- https://master.php.net/note/delete/91559/spam
Del: non-english -- https://master.php.net/note/delete/91559/non-english
Del: in docs -- https://master.php.net/note/delete/91559/in+docs
Del: other reasons-- https://master.php.net/note/delete/91559
Reject -- https://master.php.net/note/reject/91559
Search -- https://master.php.net/manage/user-notes.php