IIS Unspecified Error

[richy]

I've recently started using IIS to work on my ASP sites on a local machine not on a network.

When my asp tries to update a database, it intermittently (sp) tells me there is an Unspecified Error. If I refresh the page about ten seconds later, it works, but the next page I go to it will probably do it again.

I believe it's something to do with my IIS settings on this site but not sure what to look at. I believe all the permissions are correct, but if they weren't it would not let me update the db at all would it?

Can anyone point me in the right direction?


Thanks.

[-TPM-]

Hmm sounds like the DB connection isn't closing properly, and it's blocking other connections untill it times out.

[richy]

Thanks for the reply.

Any idea how I can fix that?

[-TPM-]

Well you'll need to check your code and make sure each time you connect to the DB you disconnect afterwards. Make sure it's getting to the disconnect code as well.