#42715 [Opn]: Consistent Connection Failed to MSSQL 2000 server
ID: 42715
User updated by: pradeep at value-one dot com
Reported By: pradeep at value-one dot com
Status: Open
Bug Type: MSSQL related
Operating System: Windows 2003
PHP Version: 5.2.4
New Comment:
This is also an ADD-ON in this regards. I had search a lot in PHP BUG
system and I found one reported issue similar to my submission however
it is also slight different.
It is "http://bugs.php.net/bug.php?id=40034" the
last submission by
"[30 Jun 6:34pm UTC] jmckinzie at novonics dot com". Instead of this
version, in my problem most of time I got disconnection from MSSQL
Server.
Previous Comments:
------------------------------------------------------------------------
[2007-09-19 21:21:29] pradeep at value-one dot com
Description:
------------
I had PHP 5.1.5 with MSSQL 2000 on IIS 6 in Windows 2003 installed and
runnning major PHP production application. Everything was working fine
except I had updated my running Windows 2003 server with Service Pack 2.
After that, I am getting Consistent Connection to MSSQL faileure by PHP.
One momemnt folowing PHP script shows 'Could Not Connect To MSSQL' and
the very nect moment it got Connected. I am not able to understand this
wired behaviour of PHP. I think it is due to BUG in PHP.
<?php
$mssqlHost = "localhost"; #notice the port
$mssqlUser = 'sa';
$mssqlPass = 'password';
$mssqlDB = 'exdb';
$s = mssql_connect($mssqlHost,$mssqlUser,$mssqlPass) or die('Could not
connect to SQL Server on '.$mssqlHost.' '.'Using '.$mssqlUser.'
'.'with
password '.$mssqlPass.' '.mssql_get_last_message());
echo $s;
?>
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=42715&edit=1
Thread (9 messages)