ID: 42715 Updated by: [EMAIL PROTECTED] Reported By: pradeep at value-one dot com -Status: Open +Status: Assigned Bug Type: MSSQL related Operating System: Windows 2003 PHP Version: 5.1.5 -Assigned To: +Assigned To: fmk
Previous Comments: ------------------------------------------------------------------------ [2007-09-22 15:30:48] pradeep at value-one dot com Thanks Jani I had already implemented PHP 5.2.4 Snapshot of developer build dated 19 September, 5:00PM but I face the same problem. The problem still lying but when I move my database server from this machine to another machine (i.e. Install and restore my MSSQL 2000 databases to different machine) then all works fine with my previous PHP as well as suggested PHP debug build (latest snapshot). I am wondering what is the exact cause of problem? if this is PHP bug then why is it not repeating when both Web Server (IIS) and Database Server (MSSQL) are on different machine. One more question, Is this debug build affect my production application (critical for my enterprise) or Does any debug build have any security vulnerability? I am asking this because right now my application running with suggested Snapshot build. ------------------------------------------------------------------------ [2007-09-21 09:07:34] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [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
