View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pbewig@gmail.com is offline
external usenet poster
 
Posts: 5
Default How to determine if a connection is active

I am writing an addin that manages an ODBC/OLEDB connection to a
database. I manage to make the connection without trouble. However, I
would like to be able to determine if the connection is still active;
for instance, the database might drop the connection if a certain
amount of time has passed without activity. How can I determine if a
connection is active?

Many thanks,

Phil