I don't know if this is possible. My program works for the most part except for when my stored procedure (which calls another stored procedure which calls yet another stored procedure) returns an error code (which is actually being returned by the 3rd stored procedure). My
VB code is NOT using a recordset because I am not retrieving data from a query. Rather I am calling a stored proc that updates a table. The output is returned through my program for the most part. That is, unless there is a certifiable error (decided by the third stored proc). If an error is returned (anything other than the typical 'The command(s) completed successfully.'. Being that I am not using a recordset, how can I get this error and use it in my error processing so that my program doesn't bomb out, as it currently does in this case. Help!