MS SQL Problem

From: Date: Fri, 31 May 2002 15:46:33 +0000
Subject: MS SQL Problem
Groups: php.general 
Request: Send a blank email to php-general+get-100110@lists.php.net to get a copy of this message
Last night, I ran into a problem when using the MS SQL support in PHP under Apache/PHP module/MS SQL 2000. Everything worked well enough. I was able to connect to the server, query data, and a number of other things. However, I found that if I ran my test page (it connects to, queries and displays 20 rows of data, then disconnects) over and over very quickly (hold CTRL+R down basically) PHP would eventually (after about 6 seconds) fail to connect to the MS SQL server. In fact, the web server would have to be completely restarted before it could connect again. Has anyone run into this? I mean, if there is no solution to this and is the cause of basically shaky MS SQL support, then the SQL server would be made useless for sites with even a modest amount of traffic (several requests per second). Is this a known problem? If so, could anyone help me out? Thanks! Justin

« previous php.general (#100110) next »