In this article, Garth discusses how to use access custom error messages generated by SQL Server with the Errors Collection of ADO. This is a follow up to the earlier Handling Errors in Stored Procedures article.
I can retrieve one error from ADODB.Connection.Errors collection but when I try to report multiple non fatal errors from a stored proc to an ADO connection/command, I can only retrieve the first one. For all the hemming and hawing various texts about ADO do regarding the Errors collection, and making sure to check for multiple errors, I would think this would work. Any ideas?
When I was in college all I wanted was to get out. Now that I'm out all I want to do is go back.