I'm using  Visual Basic 6.0, MDAC 2.6  ADO and SQL Server 2000.
I'm writing a Programm that run's 24 Hours. It makes a Connection
to the SQL Server and make some SQL Work. Now there is a Problem.
The Programm is working several hours and now the SQL Server will be
shut-down. How can i find out if the Connection to the SQL Server is
still alive ?

If i try with cn.state i get a Error and the Error number :
cn.errors.NativeError can 595 or 4 and sometimes other values

Do you know a good way to get the Information if the SQL Server
Connection is still alive ?

Best Regards
Paolo Taverna