Re: MS SQL Problem

Thanks for the reply. Actually, I am using both mssql_free_query and mssql_close along with mssql_pconnect. It still happens however. I can post the code if you are unsure. Does it have a history of threading issues as it only seems to happen when several requests are sent all at once or at least in very fast succession. Justin At 06:56 PM 5/31/2002 -0700, you wrote:

Hiya, were you using the appropriate free_query & close functions to free up the memory & more importantly the socket used to talk to the sql server? You might want to try using the _pconnect function if it's available instead of the usual _connect statement. I'd guess that PHP ran out of sockets to make outbound connections with. Also, I believe that MSSQL is setup to only have around 1000 max connections open unless you alter the value in the config. HTH, Dw Sqlcoders.com Dynamic data driven web solutions ----- Original Message ----- From: "Justin Felker" <justin@down.cx> To: <php-general@lists.php.net> Sent: May 31 2002 08:46 AM Subject: [PHP] MS SQL Problem 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php