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 "Unspecifie d Error" message.

[OleDbException (0x80004005): Unspecified error]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32
hr) +20
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() +57
System.Data.Ole Db.OleDbConnect ion.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" <mv******@yahoo .com> wrote in message
news:00******** *************** *****@phx.gbl.. .

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 "Unspecifie d Error" message.

[OleDbException (0x80004005): Unspecified error]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32
hr) +20
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() +57
System.Data.Ole Db.OleDbConnect ion.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.

[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)?

-----Original Message-----
The first thing I would check is the possiblity that you've exceeded themaximum number of concurrent connections for your Access database. If I knewthe version, I could tell you what that number is, but you can look it upfor yourself as well. Access is not designed for Internet use. It doesn'tsupport a large number of concurrent connections.

--
HTH,

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