Kane Jeeves
Active member
- Joined
- May 17, 2006
- Messages
- 44
- Programming Experience
- 5-10
I'm providing a web service to other apps. It basically does some simple checking, starts up a Subroutine asynchronously, then returns to the calling app. The Sub that's called does quite a few things including several SQL reads, inserts, call other Subs that do SQL calls, etc.
Things work fine until my service is called more than once a second. At that point I start to get various SQL-type errors, for ex. with HasRow, Reader Closed, Connection closed, etc. ("Invalid attempt to call HasRows when reader is closed", etc).
Could there be problems with asp.net getting confused when multiple threads are executing, each of which is using the same readers, connections, etc? (By "the same" I mean the same code setting up readers and connections with the same names)
As far as I know we have a very standard asp.net/iis/sql configuration.
Thanks in advance!
- Kane
Things work fine until my service is called more than once a second. At that point I start to get various SQL-type errors, for ex. with HasRow, Reader Closed, Connection closed, etc. ("Invalid attempt to call HasRows when reader is closed", etc).
Could there be problems with asp.net getting confused when multiple threads are executing, each of which is using the same readers, connections, etc? (By "the same" I mean the same code setting up readers and connections with the same names)
As far as I know we have a very standard asp.net/iis/sql configuration.
Thanks in advance!
- Kane
