Re: [PHP-WIN] php with mssql

2002-11-13 Thread soff
Dash, I am installing "Microsoft Data Access Components 2.7 RTM" and hope it will help me. Thanks for your help, best wishes. At Tue, 12 Nov 2002 23:55:28 -0800 (PST) , you wrote: > I wish I could offer more assistance... > > Here's an odd thought: Can you show me an example of where IN

Re: [PHP-WIN] php with mssql

2002-11-12 Thread Dash McElroy
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 connec

Re: [PHP-WIN] php with mssql

2002-11-12 Thread soff
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 MSS

Re: [PHP-WIN] php with mssql

2002-11-12 Thread Dash McElroy
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.

Re: [PHP-WIN] php with mssql

2002-11-12 Thread soff
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://http

Re: [PHP-WIN] php with mssql

2002-11-12 Thread Dash McElroy
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 M

Re: [PHP-WIN] php with mssql

2002-11-12 Thread soff
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 :

Re: [PHP-WIN] php with mssql

2002-11-12 Thread Dash McElroy
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

[PHP-WIN] php with mssql

2002-11-12 Thread soff
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 fo