Hope this is not OT: I am running into some strange things whenever my ASP p
ages 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 th
at 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 th
eir 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 MyS
QL is not the best combo out there, but I have no other options.  Does anyon
e 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 m
e IIS can only process one ASP to mysql request at a time - is this caused b
y the DSNless connection?  

Note, only one of the 4 simultaneous requests seems to come back OK (code 20
0).

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

[ Post a follow-up to this message ]

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
>

[ Post a follow-up to this message ]