Check which connections are still open????? 1

[ComputerCop911]

I am running a script connecting to an Access 2000 DB, and
its never done this before, but when I run a page it says

Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

my connection string looks like this:

Dim ConnectString, conn

ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("\elogin\db\users.mdb&quot & ";" & _
"Persist Security Info=False"
Set conn = Server.CreateObject("ADODB.Connection&quot
conn.open ConnectString

I was wondering how I can check which connections are still open, using either a .vbs or .asp file, and if there are any open, then close them.


ComputerCop911
ASP/HTML Programmer

 

[ComputerCop911]

by the way, YES, all my pages have tags to close the connections and set them to Nothing

ComputerCop911
ASP/HTML Programmer

 

[selani]

Hi,

This shud work...

If conn_obj.State = 1 Then
conn_obj.Close
Set conn_obj = Nothing
End If

conn_obj is the connection object

selani

 

[Webwench]

I run into this if I have the mdb file open when I try to execute.

 

[ComputerCop911]

my mdb file is closed when this happens, but the CONNECTION to it is still open.

thanks, selani!

ComputerCop911
ASP/HTML Programmer

 

[shaddow]

Try to Enable Conexion Pooling for the Access drivers and set a short value for that.

________
George, M