By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,696 Members | 1,486 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,696 IT Pros & Developers. It's quick & easy.

asp + mysql and simultaneous requests result in IIS 500 error

P: n/a

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

Jul 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <sl************@mail.webservertalk.com> wrote in message
news:sl************@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

Jul 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.