concurrency questions

  • Thread starter Thread starter Ed Staffin
  • Start date Start date
E

Ed Staffin

I am using an access db via ole db from an asp.net page.
When I open a connection, if there are no more connections
in IIS's connection pool it'll try and open a new
connection. If there are no more connections available
what exception get's thrown?

By the same token, when using a data adapter to do an
update, what exception gets thrown if the server (the
access mdb) is busy?

Lastly, where can I read up on this. I already know about
switching the MSDE etc. Sounds great, but not an option
for the near term.

Thanks ... Ed
 
Hi Ed,

Ed Staffin said:
I am using an access db via ole db from an asp.net page.
When I open a connection, if there are no more connections
in IIS's connection pool it'll try and open a new
connection. If there are no more connections available
what exception get's thrown?
Click to expand...

I think that connections are managed by oledb.net provider and you'll get an
OleDbException (I think its ErrorCode should be 0x80004005 however this is
not significant - you have to check Errors collection for native errors
though there is only an unspecified error with native code 0).
By the same token, when using a data adapter to do an
update, what exception gets thrown if the server (the
access mdb) is busy?
Click to expand...

An OleDbException with same ErrorCode as above and at least on native error
with NativeError 0xe02efbb2.
Lastly, where can I read up on this. I already know about
switching the MSDE etc. Sounds great, but not an option
for the near term.
Click to expand...

I think that OLE DB Programmer's Reference in the MSDN library located at
http://msdn.microsoft.com/library have some details.
Or any other OLE DB documentation...

You might also simulate the situation and see what exceptions you get.
 
Back
Top