ADODB CONNECTION

[M.Savino]

Let's you know if the Connection is Open or Closed.

[PrincessAmidala]

I am having errors when running my program on whether the connection to the database is open or close. In every function that i open a connection, i always close it at the end of the function.My problem is, if the user close the program during run time in the middle of the function, the connection may not be closed and may cause a run time errors. Is there any way to check the status of the adodb connection?

[T.Grove]

If this is a windows forms app, close your connection in a dispose subroutine. That way if the program gets closed, the disposing call will close the connection.