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" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
