#20916 [Opn->Bgs]: MS SQL: Unable to connect to server
ID: 20916
Updated by: iliaa@php.net
Reported By: CharlesK@netgaintechnology.com
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: Windows 2000 Server
PHP Version: 4.2.3
New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system
is not the
appropriate forum for asking support questions.
Thank you for your interest in PHP.
It is possible that netscape sets a different host enviroment variable
then the one set by IE and the one set in cli, which causes the SQL
server reject the connection. That's just about the only thing I can
come up with as the possible reason for this problem.
Try using the mssql_get_last_message() in the event of connection
failure to determine why the connection fails. If it does due to a
permission error, then my assumption as to the cause of the problem is
likely to be correct.
Previous Comments:
------------------------------------------------------------------------
[2002-12-10 09:54:19] CharlesK@netgaintechnology.com
What else could be causing PHP to generate this error only in this
case?
Sorry for continuing this but I do not believe this that PHP plays no
part in this error. I host around 40 sites all with php and most with
database.
I would just like an answer to what could cause this.
Again sorry for reopening again. This is my last attempt.
------------------------------------------------------------------------
[2002-12-10 09:40:59] sniper@php.net
If it works with IE or from command line, it CAN NOT BE A BUG IN PHP..
------------------------------------------------------------------------
[2002-12-10 09:22:18] CharlesK@netgaintechnology.com
But PHP is generating the error:
MS SQL: Unable to connect to server
If it is entirely within Netscape, PHP should not display this error.
I am sorry for reopening this.
------------------------------------------------------------------------
[2002-12-10 08:59:33] sniper@php.net
Yes, browser can't possibly affect this.
Thus this is bogus. (propably some cache issue with NS)
------------------------------------------------------------------------
[2002-12-10 08:48:53] CharlesK@netgaintechnology.com
<?
$username = 'dbusername';
$password = 'dbpassword';
$connection = mssql_connect('192.168.168.168',$username,$password);
?>
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/20916
--
Edit this bug report at http://bugs.php.net/?id=20916&edit=1
Thread (9 messages)