|
Home > Archive > IIS ASP > December 2004 > asp + mysql and simultaneous requests result in IIS 500 error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
asp + mysql and simultaneous requests result in IIS 500 error
|
|
| slugger 2004-12-28, 10:46 am |
| 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 | |
| Ray Costanzo [MVP] 2004-12-28, 9:00 pm |
| 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
>
|
|
|
|
|