Is ther any way to validate connection

Platform : VC++ 2005

Datababse : Oracle, SQLServer, MS Access

OS : XP, Window 2003



Hi,



I have developed an application which uses OleDb to open connection. Once
connection is open program cache this connection for further use. Some time
connection become invalid. Is there any way to check connection which has
been cached is valid?



Thanks



Vijay Singh

EDISPHERE