The Connection objects properties collection

This displays a lot of information about a connection .

Code :

<%
Dim adOpenForwardOnly , adLockReadOnly , adCmdTable
adOpenForwardOnly = 0
adLockReadOnly = 1
adCmdTable = 2
Dim objConn , objProp
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = D:\asp\example.mdb"
For Each objProp In objConn.Properties
Response.Write objProp.Name & "&nbsp" & objProp.Value & "<br>"
Next
objConn.Close
Set objConn = Nothing
%>

Notes :

You can download the database used here