Connection error

[spyder]

When Connected to a Database with ADO, and using a DSN, The database Times out and then can not be opened again Until My IIS Server resets the database after 3 minutes. It acts like the Connection is never closed.

My last ASP Lines are

rsProducts.close
DBObj.close

Anyone have any Ideas as to how stop this from happening

Thanks in Advance
Spyder

[Mark Sreeves]

I dunno!

Try adding:

Set rsProducts = Nothing
Set DBObj = Nothing

after closing them.

[spyder]

I also have that in My code and it seems to make no Difference. I have tried with and without the Nothing Lines. Still the Same thing.

Anyone else have any Idea?

Spyder

Perhaps the server is keeping the db locked for some reason...you know...the way a program locks a file when you're editing it.

There's a NT4 server I use that does this every so often. I assume this is the reason because the same server sometimes locks my asp files and when I try to save them I get a permission denied error coz it thinks the file is still open by someone else.

I don't know the cause of this happening. Try messsin around with IIS's settings and see if it does put a read-lock on files when it's using them...there might be a setting that keep sthe file locked for a short time afterwards?