RDO Error Handling -howto? (example: database falls) 
Author Message
 RDO Error Handling -howto? (example: database falls)

Hello,

I relatively new to VB and I have a questions regarding the correct
method of error handling when working with a remote database.

I am working with VB 5 and MS SQL Server using RDO to access the
database. I have an application that receives data on aprox 15 second
interval from a TCP stream and logs it to the database.  This will be
running as a Win NT service. I am working with an asynchronous
connection using stored procedures to insert data.

My question is what is the proper method of handling database connection
errors, i.e.. the database crashes, becomes unavailable, etc..?

How do I detect that the connection to the database is open?

How do I reconnect while waiting for the database to comeback online.
The StillConnecting property goes false after a connection time-out and
I have no way of determining if I am connected or not (I may be missing
something).

Any help would be appreciated.

Thanks,

Stuart

--
======================================================================
=  Stuart Haas                                                       =

=  1 Korazin St.                   Tel: +972-3-5715163               =
=  Givataim 53583   Israel         Fax: +972-3-5715167               =
======================================================================



Sat, 11 Dec 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. RDO Error Handling -howto? (example: database falls)

2. HOWTO Handle Related databases

3. Problem VB4 RDO, Multiple Selects for Stored Proc Error Handling

4. Error Handling: Simple Example?

5. RDO Error Handling

6. Good VB/COM+/ADO Error Handling Examples?

7. ***HELP : Error Handling Problem Using RDO

8. RDO Error Handling

9. RDO Error Handling

10. I'm falling down in VB4pro database programming

11. RDO Error 429 - Like to confirm if RDO available from VB Prof

12. RDO Error 429 - Like to confirm if RDO available from VB Prof

 

 
Powered by phpBB® Forum Software