How to catch connection timeout exception

A

Abhi poddar

Hi,
In our application we are required to raise exception if the sql server
is stopped.
We have link table from access 2003 to sql 2000. When the report is opened
after stopping the sql server services the I am getting following error :
-----------------------------------------------------------
Microsoft SQL Server Login
-----------------------------------------------------------
Connection failed:
SQL Server Error: 53
SQL Server does not exist or access denied.
-----------------------------------------------------------
We are required to capture this exception in Access solution and the raise a
customized exception.
Any help in catching connection timeout exception will be great ...

Cheers,
Alpha
 
Top