Soff, What web server are you using? I know that if you use Apache (which has a max threads (?) paramater of 150) against MySQL (default: 100) and pconnect, the database can start to deny new connections. You may be running into the same issue here. Look at your max number of connections.
I have no idea why INSERT/UPDATE queries wouldn't work with a normal connect. I'm not an MSSQL user... p.s. don't worry about your english. You type it better than most americans I know... -Dash In a five year period we can get one superb programming language. Only we can't control when the five year period will begin. On Wed, 13 Nov 2002, soff wrote: > hello, > > I am trying to connect mssql with php, when I use mssql_pconnect(), It > will fail to connect when the amount of visitors becomes large. But, > when I use mssql_connect(), I can only run SELECT quern, while the > INSERT/UPDATE staments doesn't work. Can somebody tell me why? thanks > and sorry for my poor English :P > -- > Welcome to http://www.soff.net > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
