asp.net ms-access oledb connection open error

[Mathew Vording]

Hi.

I have an application that after using it for a while,
continually forcing it to hit the database it will fail on
connection open with the OLEDB "Unspecified Error" message.

[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32
hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203


I explicitly close all connections to the database when the
page has finished executing.

Has anyone come across this?

How do I handle this?

Thanks.

 

[Kevin Spencer]

The first thing I would check is the possiblity that you've exceeded the
maximum number of concurrent connections for your Access database. If I knew
the version, I could tell you what that number is, but you can look it up
for yourself as well. Access is not designed for Internet use. It doesn't
support a large number of concurrent connections.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Neither a follower nor a lender be.

 

[Mathew Vording]

Hi:

This is during testing of the application with only myself
submitting requests. Some pages have multiple
frames/iframes though.

Is it possible this is a memory garbage collection issue?

Or would it be better to just use the MSDE for this instead
of Access (this app is aimed at only a few users)?