php-windows Digest 13 Nov 2002 18:59:28 -0000 Issue 1438
Topics (messages 16912 through 16929):
Re: php with mssql
16912 by: Dash McElroy
16913 by: soff
16914 by: Dash McElroy
16916 by: soff
16917 by: Dash McElroy
16918 by: soff
16919 by: Dash McElroy
16920 by: soff
16924 by: Carlos Andre Marques Moreira
16925 by: Matt Kynaston
16926 by: soff
Preconfigure Php+MySql+Apache bundle for Win9x
16915 by: Muhammad Imran
Re: PHP 4.2.3 / Windows 2000 / Apache 1.3.* / Install Prob
16921 by: Nenad Djordjevic
16922 by: Steel
Re: [PHP-DB] php with mssql
16923 by: soff
Re: header:location question = PROBLEM SOLVED
16927 by: Daniel Sturk
Permission denied with copy function..
16928 by: Step Schwarz
16929 by: Scott Carr
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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
>
>
--- End Message ---
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
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
>
>
--- End Message ---
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
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
>
>
--- End Message ---
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
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
>
>
--- End Message ---
--- Begin Message ---
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 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
>
--
Welcome to http://www.soff.net
--- End Message ---
--- Begin Message ---
Hi,
that's very strange. I use mssql_connect and i can execute all statements:
Select, Insert, Update, Delete, Stored Procedures with or without
parameters.
Wouldn't it be a SQL Syntax error?
BTW, my configurationg is W2K + IIS 5.0 + PHP 4.2.2 + MS SQL Server 7.0
Carlos André Marques Moreira
SENAI-CE / CETAE
[EMAIL PROTECTED]
-----Original Message-----
From: soff [mailto:soff@;263.net]
Sent: quarta-feira, 13 de novembro de 2002 03:56
To: [EMAIL PROTECTED]
Subject: php with mssql
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
--- End Message ---
--- Begin Message ---
> 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.
Just a thought - are you using the developer (ie MSDN subscription) version
of SQLServer? That limits connections to 10 - and since mssql_pconnect will
leave the connection open between hits you might be running out.
mssql_connect issues - very strange. Profiler (from MSSQL client tools) is
your friend - you can actually see what the db thinks is going on.
MDAC 2.7 probably won't change anything. The mssql_* functions are built on
top of the ancient dblib. That dates from the days when MSSQL was Sybase,
and hasn't changed since. It has it's own set of quirks and bugs that will
never now be fixed (limits on length of varchar, weirdness with
ansi_nulls... search the newsgroups) :(
I now always use odbc_* functions (Win2K, PHP4.2.2, IIS) - just don't try to
open more than one result set at a time :-|
Matt
--- End Message ---
--- Begin Message ---
Thanks for your help.
My SQLServer version is Enterprise, there is no connection limit.
MDAC2.7 have no help as you said :(
ÄúÔÚ Wed, 13 Nov 2002 11:57:19 -0000 µÄÀ´ÐÅÖÐÌáµ½:
> > 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.
>
> Just a thought - are you using the developer (ie MSDN subscription) version
> of SQLServer? That limits connections to 10 - and since mssql_pconnect will
> leave the connection open between hits you might be running out.
>
> mssql_connect issues - very strange. Profiler (from MSSQL client tools) is
> your friend - you can actually see what the db thinks is going on.
>
> MDAC 2.7 probably won't change anything. The mssql_* functions are built on
> top of the ancient dblib. That dates from the days when MSSQL was Sybase,
> and hasn't changed since. It has it's own set of quirks and bugs that will
> never now be fixed (limits on length of varchar, weirdness with
> ansi_nulls... search the newsgroups) :(
>
> I now always use odbc_* functions (Win2K, PHP4.2.2, IIS) - just don't try to
> open more than one result set at a time :-|
>
> Matt
>
--
Welcome to http://www.soff.net
--- End Message ---
--- Begin Message ---
Can any one tell me that from where I can get the reconfigured Php+MySql+Apache
bundle for Win9x.
Thank you,
Imran
--- End Message ---
--- Begin Message ---
Hello Matt,
I use apache server on Win 2k machine too.
PHP is installed in folder `c:/www/php/`
In apache httpd.conf I add lines:
ScriptAlias /php/ "C:/www/php/"
AddType application/x-httpd-php .php .php3 .phtml
Action application/x-httpd-php "/php/php.exe"
________________________
Best regards,
Nenad Djordjevic mailto:nenad@;diyomisoft.com
Diyomi Soft
http://www.diyomisoft.com/
Tuesday, November 12, 2002, 3:35:38 PM, you wrote:
M> Hey
M> Iam setting up PHP on my apache server on a windows 2000 machine. ive
M> followed all the instructions and no luck. ive copyed the dlls folder and
M> the php4ts.dll to my c:/WINNT/System32 folder and ive copyed php.ini to
M> c:/winnt. ive added these lines to my apache
M> LoadModule mod_php4 c:/php/sapi/php4apache.dll
M> Addtype application/x-httpd-php .php
M> and ive tried to add
M> addmodule mod_php4
M> and i get the same error message each time i start with or withou the
M> addmodule
M> santax error on line 153 of c:/program files/apache/apache
M> group/conf/httpd.conf :
M> cant locate API module structure 'mod_php4.c' in
M> c:/php/sapi/php4apache.dll:(127) the specified procedure could not be found
M> :
M> anybody help ???
--- End Message ---
--- Begin Message ---
Hi Nenad,
Wednesday, November 13, 2002, 11:38:59 AM, I've got:
ND> I use apache server on Win 2k machine too.
ND> PHP is installed in folder `c:/www/php/`
ND> In apache httpd.conf I add lines:
ND> ScriptAlias /php/ "C:/www/php/"
ND> AddType application/x-httpd-php .php .php3 .phtml
ND> Action application/x-httpd-php "/php/php.exe"
ND> Tuesday, November 12, 2002, 3:35:38 PM, you wrote:
M>> Hey
M>> Iam setting up PHP on my apache server on a windows 2000 machine. ive
M>> followed all the instructions and no luck. ive copyed the dlls folder and
M>> the php4ts.dll to my c:/WINNT/System32 folder and ive copyed php.ini to
M>> c:/winnt. ive added these lines to my apache
M>> LoadModule mod_php4 c:/php/sapi/php4apache.dll
M>> Addtype application/x-httpd-php .php
M>> and ive tried to add
M>> addmodule mod_php4
M>> and i get the same error message each time i start with or withou the
M>> addmodule
M>> santax error on line 153 of c:/program files/apache/apache
M>> group/conf/httpd.conf :
M>> cant locate API module structure 'mod_php4.c' in
M>> c:/php/sapi/php4apache.dll:(127) the specified procedure could not be found
M>> :
M>> anybody help ???
It seems to me, that Matt tries to install PHP as Apache sapi module.
And You installs it as external cgi.
Sapi installation is better than cgi, to find out why read
Your_Php_folder/install.txt
To install as sapi you need:
I've copied php4apache.dll and php4ts.dll to ApacheRoot/modules
folder.
LoadModule php4_module modules/php4apache.dll
AddType application/x-httpd-php .php .php3 .phtml
! Without AddModule command.
On my System Win2K & Apache 1.3.27 & PHP 4.2.3 it works perfect!
Good Luck.
--
The Same,
Steel mailto:asergey@;inbox.ru
http://www.none.ru
--- End Message ---
--- Begin Message ---
Hello,
My env is Win2000 Server + php lastest STABLE + Aapache 2.0.43 + MS SQL
Server 2000(SP2).
ÄúÔÚ Wed, 13 Nov 2002 13:50:25 +0530 µÄÀ´ÐÅÖÐÌáµ½:
> Hi Soff,
> Can U briefly explain in which platform is PHP running?
> Regards
>
>
> -----Original Message-----
> From: soff [mailto:soff@;263.net]
> Sent: Wednesday, November 13, 2002 12:47 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] php with mssql
>
>
> 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 Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Welcome to http://www.soff.net
--- End Message ---
--- Begin Message ---
thanks alot
the problem was solved easily with this code:
(i forgot to tell that i the url arrived from another page)
<script language="Javascript">
function fwdPage()
{
location="<?php print $url; ?>";
}
</script>
<body onload="fwdPage()">
best regards
Daniel
----- Original Message -----
From: "RS Herhuth" <[EMAIL PROTECTED]>
To: "Daniel Sturk" <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 2:59 PM
Subject: RE: [PHP-WIN] header:location question
>
> Daniel,
>
> You could use a blank page that contains the javascript:
>
> <script language="Javascript">
>
> function fwdPage()
> {
> location="mms://www.anotherstreamingserver.com/actualstream.wmv";
> }
> </script>
>
>
> and in the body tag put:
>
> <body onload="fwdPage()">
>
>
> This page will be transparent to the user but immediately forward them to
> the URL.
>
> Hope this helps!
> Ron
>
>
> -----Original Message-----
> From: Daniel Sturk [mailto:lists@;skurk.mine.nu]
> Sent: Friday, November 08, 2002 5:16 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] header:location question
>
>
> im was eariler using this function
> header("Location: http://www.somestreamingserver.com/actualstream.wmv";);
>
> now the provider wants me to use the following url to access the stream
>
> "mms://www.anotherstreamingserver.com/actualstream.wmv" and this doesnt
> work at all with the header redirect
>
> any ideas?
> im quite new at this
> thanks
> daniel
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Sorry to post two questions in the space of 24 hours, but I'd very much
appreciate a fresh pair of eyes. I built a content management area for a
client to assist with managing text in their MySQL employee database and
uploading photos directly to their server. Works fine in our test
environment but we're getting errors on the live site which look like this:
Warning: Unable to create 'd:\My Website\images\library\
emps79.jpg' Permission denied in D:\My Website\service\emps.php on line 110
Line 110 of the emps.php file contains the copy function.
Unfortunately I do not have direct access to the server, but the client has
checked permissions on both the temp directory and the directory specified
in the warning and both grant the Everyone user Full Access.
The server is Windows 2000, IIS 5.
The only thing that really sticks out to me is there's a space in the file
path -- do you think that could be causing a permission denied error?
Unfortunately I'm not sure I have any control over how that "My Website"
directory is named, so if you do think that's the culprit, any workaround
would be much appreciated.
Thank you in advance,
-Step
--- End Message ---
--- Begin Message ---
What user is IIS running as? Does it have access to those directories?
--
Scott Carr
Documentation Maintainer
http://documentation.openoffice.org
OpenOffice.org
Quoting Step Schwarz <[EMAIL PROTECTED]>:
> Sorry to post two questions in the space of 24 hours, but I'd very much
> appreciate a fresh pair of eyes. I built a content management area for a
> client to assist with managing text in their MySQL employee database and
> uploading photos directly to their server. Works fine in our test
> environment but we're getting errors on the live site which look like this:
>
> Warning: Unable to create 'd:\My Website\images\library\
> emps79.jpg' Permission denied in D:\My Website\service\emps.php on line 110
>
>
> Line 110 of the emps.php file contains the copy function.
>
> Unfortunately I do not have direct access to the server, but the client has
> checked permissions on both the temp directory and the directory specified
> in the warning and both grant the Everyone user Full Access.
>
> The server is Windows 2000, IIS 5.
>
> The only thing that really sticks out to me is there's a space in the file
> path -- do you think that could be causing a permission denied error?
> Unfortunately I'm not sure I have any control over how that "My Website"
> directory is named, so if you do think that's the culprit, any workaround
> would be much appreciated.
>
> Thank you in advance,
> -Step
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
--- End Message ---
