Not receiving any error notifications from ADO 
Author Message
 Not receiving any error notifications from ADO

I have an ADO connection and an ADO command. The connection opens just fine,
and I can create and assemble a valid command. The command is connecting to
a Stored Procedure in MSSQL 7.0. The stored procedure is using "RaisError"
to report and error, such as trying to delete a default piece of data.
However, my code which simply creates the command, adds parameters, and
executes does not cause any errors to be returned to the VB app. Now, if I
actually inspect the Errors collection, the message is there, but it just
doesn't cause the app to pause or throw to an error handler or anything. Why
is that. Does this have to do with the severity level of the error or
something like that?

Matthew



Sat, 16 Feb 2002 03:00:00 GMT  
 Not receiving any error notifications from ADO
I figured it out. Severity levels 1-10 do not produce any error messages
other than just to the collection. No notifications unless 11 or higher.
Duh.


Quote:
> I have an ADO connection and an ADO command. The connection opens just
fine,
> and I can create and assemble a valid command. The command is connecting
to
> a Stored Procedure in MSSQL 7.0. The stored procedure is using "RaisError"
> to report and error, such as trying to delete a default piece of data.
> However, my code which simply creates the command, adds parameters, and
> executes does not cause any errors to be returned to the VB app. Now, if I
> actually inspect the Errors collection, the message is there, but it just
> doesn't cause the app to pause or throw to an error handler or anything.
Why
> is that. Does this have to do with the severity level of the error or
> something like that?

> Matthew




Sat, 16 Feb 2002 03:00:00 GMT  
 Not receiving any error notifications from ADO
Rdo has an ErrorTreshold property to control this behaviour. Maybe
ado has something simmillar?

    Christer Romson

Matthew Roberts

Quote:
>> Severity levels 1-10 do not produce any error messages
>> other than just to the collection. No notifications unless 11 or higher.

Matthew Roberts:
Quote:
>> The stored procedure is using "RaisError" to report and error
>> My code does not cause any errors to be returned to the VB app. Now, if I
>> actually inspect the Errors collection, the message is there, but it just
>> doesn't cause the app to pause or throw to an error handler or anything.



Sun, 17 Feb 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Receiving notification on Send, Receive and Delete

2. ADO & SQL-Server error notification

3. How to receive file change notification in VB6?

4. send/receive notifications

5. Send/Receive Notification

6. Receiving notification on Save

7. Receive a notification from windows when the system is idle

8. How to receive file change notification in VB6?

9. Receiving notification about changes(adding or removing ActiveX controls) in the container

10. FTP Notification when a file is received

11. How to receive file change notification?

12. Receiving ADO error when opening db

 

 
Powered by phpBB® Forum Software