Dash, Thanks for you answer, my env is Win2000 Server + php lastest STABLE + Aapache 2.0.43 + MS SQL Server 2000(SP2). Can you tell me how to configure the max threads and let mssql_pconnect() work well. It think that mssql_pconnect() will be better than mssql_connect() if they both work well :P
At Tue, 12 Nov 2002 23:04:43 -0800 (PST), You Write: > 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 > > > > > -- Welcome to http://www.soff.net -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
