Re: asp + mysql and simultaneous requests result in IIS 500 error

From: Ray Costanzo [MVP] (my)
Date: 12/29/04 

Date: Tue, 28 Dec 2004 21:53:44 -0500

It's kinda hard to say without knowing ~what~ the error is. Perhaps it has
to do with XP's limitation of only 10 connections at a time.

Ray at home

"slugger" <slugger.1i00d1@mail.webservertalk.com> wrote in message
news:slugger.1i00d1@mail.webservertalk.com...
>
> Hope this is not OT: I am running into some strange things whenever my
> ASP pages send out simultaneous requests to another ASP page which in
> turn gains access to a MySQL database using a DSNless connection
> string.
>
> Whenever I run a page that just puts out a single request things seem
> to go fine, but if I activate some Flash components that reside on my
> ASP pages that put out requests to ASP pages which in turn try to
> retrieve data from the MySQL database, I get a 500 error code. These
> Flash files try to update their data every other 5 seconds and they do
> so simultaneously - however there are never more than 4 simultaneous
> request at one particular time.
>
> I am running XP (sp2) with IIS 5.1. I am aware of the fact that ASP
> and MySQL is not the best combo out there, but I have no other options.
> Does anyone know why IIS returns 500 error codes on simultaneous
> requests? Would that be a MySQL issue? Why does this bog down and
> cause "Page cannot be display
> ed" on other asp pages that don't send simultaneous requests? It seems
> to me IIS can only process one ASP to MySQL request at a time - is this
> caused by the DSNless connection?
>
> Note, only one of the 4 simultaneous requests seems to come back OK
> (code 200).
>
> Here is a snippet of the IIS log file:
>
> 14:39:08 127.0.0.1 GET /test/test.asp 500
> 14:39:08 127.0.0.1 GET /test/test.asp 500
> 14:39:08 127.0.0.1 GET /test/test.asp 500
> 14:39:08 127.0.0.1 GET /test/test.asp 200
> 14:39:12 127.0.0.1 GET /test/test.asp 500
> 14:39:12 127.0.0.1 GET /test/test.asp 500
> 14:39:12 127.0.0.1 GET /test/test.asp 500
> 14:39:12 127.0.0.1 GET /test/test.asp 200
>
> Any help would be appreciated!!
> Thanks
>
>
>
> --
> slugger
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message844758.html
>

Relevant Pages

  • asp + mysql and simultaneous requests result in IIS 500 error
    ... ASP pages send out simultaneous requests to another ASP page which in ... ASP pages that put out requests to ASP pages which in turn try to ... retrieve data from the MySQL database, I get a 500 error code. ... ed" on other asp pages that don't send simultaneous requests? ...
    (microsoft.public.inetserver.asp.general)
  • Re: MySQL and ASP
    ... >to establish a DSN-less connection to a MySQL database using ASP? ... As for the driver setup, you'll want to check the MySQL docs: ...
    (microsoft.public.inetserver.asp.db)
  • Re: Efficient Connection To MySQL
    ... connection to mysql for every query. ... What proportion of time is actually spent on connection vs the rest of the ... Since you mention AJAX then each of these requests is a new PHP request - ...
    (comp.lang.php)
  • Re: How much should I need to Dispose() of
    ... > Dispose won't help if the connection is orphaned or still in use. ... > Connection pool timeouts are caused by one thing: ... Suppose your ASP page takes 5 seconds to ... In practice ASP will generally not allow that many simultaneous requests to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ASP.NET Databound controls and connection pools --> How does it work?
    ... In J2EE you have to configure connection pools in the container for every application. ... I hope ASP connection pools are also on application context and not on page context! ... also as you do not lock the connection during use, two page requests that try to use the connection at the same time will fail. ...
    (microsoft.public.dotnet.framework.aspnet)