#42715 [Opn->Fbk]: Consistent Connection Failed to MSSQL 2000 server

ID: 42715 Updated by: jani@php.net Reported By: pradeep at value-one dot com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows 2003 PHP Version: 5.1.5 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi Previous Comments: ------------------------------------------------------------------------ [2007-09-20 06:08:58] pradeep at value-one dot com 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. ------------------------------------------------------------------------ [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