Miha
Thu May 13 03:03:59 CDT 2004
Hi Ed,
"Ed Staffin" <anonymous@discussions.microsoft.com> wrote in message
news:c34101c43848$92bf2e20$a301280a@phx.gbl...
> 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?
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?
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.
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.
--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com