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 
