Disk or network error

[wilberforce2]

I have a VB6 app running across the network connected to a database. I am getting occasional Disk or network errors and was wondering how the best way to trap the error so that the app does not bomb out. The app uses a mapped network drive that works fine after a disk or network error occurs. The database seams to be more sensitive.

Any ideas would be appreciated.

Thanks

 

[BobRodes]

Inline example:

on error resume next
do
    err.clear
    [code=line to access network goes here]
loop until err.number = 0

Handler example:

on error goto errhandle
[code=line to access network goes here]
exit sub 'always put before errhandle tag, to avoid executing error handler if error doesn't occur
errhandle: 'best at end of code
if err.number = [number of error you're trapping] then
     resume 'here you could put a counter and quit if you've tried to resume x times
end if

HTH

Bob