--Original Message-----
From: Tony Foate [mailto:tony@f...]
Sent: 04 June 2000 00:36
To: support@w...
Subject: Professional Visual Basic 6 Databases Charles Williams 2025


Hi ..
Chapter 10 talks about capturing OLE DB Provider Errors (page 324). 
Chapter
7 at page 242 helps.

I am trying to trap MS SQL Server login, connection and timeout errors 
from
my VB6 program. However, the provider (login script, driver) insists on
displaying it's own messages (stops the program and displays a message 
box).
Can I trap the errors in my program and avoid the message box? I want to 
let
my program record the event, and keep on running (my application has to 
run
unattended in a scheduled state).
The On Error command does not seem to trap these areas.
Your advice would be appreciated.
Tony Foate