I am writing a component(written in VC++ 6.0 IDE, using MS ADO 2.5) which
has database support and uses MS SQL Server 2000 as a back-end. My component
should behave as it has persistent database connection, I.e. whether it is
possible to provide clients with database connection. That's why, I wish to
make my component to be smart enough to detect database connection closure.
In this case, it should automatically try to reconnect. I try to find some
MSSQL2k error codes for connection closure, but I didn't found anything on
I will be thankful if you have some suggestions how to solve my problem.