MS Access + IIS + Impersonation = 'Unspecified Error'?

Question

I have an ASP .NET (2.0) app that connects to an Access database over a network share using impersonation and basic authentication in IIS. Everything was working fine up until today, when I started getting weird 'Unspecified Error' error messages. I ended up doing an IIS reset to resolve the problem, but I'm trying to figure out why it may have happened in the first place.

Any ideas? Here is my connection string: provider=Microsoft.Jet.OLEDB.4.0;Data Source = \REMOTESERVER\LocalDatabases$\database.mdb;Jet OLEDB:Database Password=password"

Thanks in advance!

Answer 1

If everything was working fine up until today, something must have changed. If no one has changed the code or configuration for IIS, then it must be something else on the server (or the network share).

Given that we just went though a patch-Tuesday, I would suspect that someone updated either the webserver or the network server. See if there is a patch you can roll-back .

Answer 2

I don't know about OLEDB, but with ODBC, it is often the case that more than one error is returned by ODBC, and the last one is all you get notified about until you specifically check the ODBC errors collection. Perhaps OLEDB is returning more than one error, and one of the other errors in the error collection might be more illuminating.

--
David W. Fenton
David Fenton Associates

Answer 3

Hi!

Check if you are closing properly the database at the end of your routines. This can cause these messages eventually.

Bye!