Error 500 on second Open to Access Database

[SteveB]

Using ASP under IIS (Win2k3 Server), latest patches.

I have an simple page that accesses an Access database via a system
DSN. The first Open works fine, but each subsequent time (page
reload, relogin, etc) I get either an Error 500 (HTTP error) or an ASP
"Unspecified error" message on the Open line.
* The IUSR account has Full Privs to the directory containing the
Access database
* the IUSR account has Full Privs to the database itself
* Even tried giving full access to the IWAM account, but that didn't
matter
* Am setting the objConnection.Mode property to 3 (adModeReadWrite)

Problem goes away after the database has a minute or two to
(apparently) unlock something, I guess: as soon as I do another Open
it works, but then stops working again until I let it sit. Privs are
fine, but I know I've had this problem before and resolved it on other
sites.

Thoughts? And yes, I've been to ASPFAQ.com; couldn't find anything
that helped.

Jack

[Ken Schaefer]

Hi,

a) Please uncheck "Show Friendly HTTP Errors" in your copy of Internet
Explorer (Tools -> Options -> Advanced)
b) Reload the page and post the exact error message you are seeing.

Also, you need to make sure you are explicitly closing your ADO connection
objects - so that they are returned to the ODBC Connection pool. If you are
implicitly creating connection objects (by using Recordset.Open
<connectionString>) you should adjust your code so that you explicitly
create a connection object and use that when opening your recordset.

Cheers
Ken


"SteveB" <mcse4cash@hotmail.com> wrote in message
news:6b35f956.0406132019.3e7b344b@posting.google.c om...
: Using ASP under IIS (Win2k3 Server), latest patches.
:
: I have an simple page that accesses an Access database via a system
: DSN. The first Open works fine, but each subsequent time (page
: reload, relogin, etc) I get either an Error 500 (HTTP error) or an ASP
: "Unspecified error" message on the Open line.
: * The IUSR account has Full Privs to the directory containing the
: Access database
: * the IUSR account has Full Privs to the database itself
: * Even tried giving full access to the IWAM account, but that didn't
: matter
: * Am setting the objConnection.Mode property to 3 (adModeReadWrite)
:
: Problem goes away after the database has a minute or two to
: (apparently) unlock something, I guess: as soon as I do another Open
: it works, but then stops working again until I let it sit. Privs are
: fine, but I know I've had this problem before and resolved it on other
: sites.
:
: Thoughts? And yes, I've been to ASPFAQ.com; couldn't find anything
: that helped.
:
: Jack