Peter J. Boettcher — Fri, 10 May 2002 12:36:25 +0000

The code I always use is:

If objADOConnection.State Then objADOConnection.Close
Set objADOConnection = Nothing
End If

objADOConnection is my ADO Connection. This If statement detects if the connection is open and closes it if it is.

necrotic — Fri, 10 May 2002 00:17:16 +0000

O, didn't look at the <% tags... o well. I don't know ASP.

dk01 — Thu, 09 May 2002 10:10:25 +0000

I think they want ASP code.
You could probly do something like this:

Set Conn = Server.CreateObject("ADODB.Connection") 
ConnString = "Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)}; "
ConnString = ConnString & "DBQ=" & Server.MapPath("\path\datbase.mdb") & "; "
ConnString = ConnString & "PWD=databasepassword"
Set OpenConn = Conn.Open(ConnString)
If Not OpenConn=0 Then
Response.Write "Database opened"
End If

That code would probably work (may take some tweaking) but the problem is that ASP would give you an error before you even get to check for the connection being open. If you could turn off these errors then you might be able to work out some sort of way to do it.
Good luck.
-dk

necrotic — Thu, 09 May 2002 00:00:03 +0000

<?php
if (!$connection) {
  echo $connection;
}
?>

Is that what you want?