I wish I could offer more assistance... Here's an odd thought: Can you show me an example of where INSERT or UPDATE code returns with '1'? What does it return for pconnect?
-Dash Celebrate Hannibal Day this year. Take an elephant to lunch. On Wed, 13 Nov 2002, soff wrote: > With normal connection, I can run SELECT well, so the connection must be > successful. What's more, the result of UPDATE/INSERT returns "1", I have > no idea now..... > > Can you help me? My god... > > 您在 Tue, 12 Nov 2002 23:42:10 -0800 (PST) 的来信中提到: > > > Honestly - I have no idea how to do this in MSSQL. Those instructions are > > for limiting the Apache server. > > > > The mssql_connect shouldn't be an issue because the connection is torn > > down when the php page is done (or mssql_close (?) is called), but you > > said you have experienced issues with that call. > > > > -Dash > > > > A computer, to print out a fact, > > Will divide, multiply, and subtract. > > But this output can be > > No more than debris, > > If the input was short of exact. > > -- Gigo > > > > On Wed, 13 Nov 2002, soff wrote: > > > > > Sigh... > > > > > > I seems so difficult :( > > > > > > How about the normal connect :P > > > > > > Thanks > > > > > > 您在 Tue, 12 Nov 2002 23:25:27 -0800 (PST) 的来信中提到: > > > > > > > This could be the configuation entry for Apache2 on Win2k: > > > > > > > > http://httpd.apache.org/docs-2.0/mod/mpm_common.html#threadsperchild > > > > > > > > Or this: > > > > > > > > http://httpd.apache.org/docs-2.0/mod/mpm_common.html#maxclients > > > > > > > > If not, look here: > > > > > > > > http://httpd.apache.org/docs-2.0/mod/quickreference.html > > > > > > > > and search for Max. You're bound to find something. > > > > > > > > My database stuff uses pconnect as well. I've never timed it or anything, > > > > but it just seems to make more sense to do so. > > > > > > > > -Dash > > > > > > > > Never make anything simple and efficient when a way can be found to > > > > make it complex and wonderful. > > > > > > > > On Wed, 13 Nov 2002, soff wrote: > > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > -- > > > 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 > > > > -- > 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
