Ansi SQLSTATE error codes

[Silverbeard]

HI

I am currently trying to retrieve SQLSTATE error codes through ADO from SQL Server to conduct proper error handling, but i can't seem to find a listing of these error codes anywhere. Can somebody help?

I have written an application that automates database upgrades at the client site and since i have no idea what version of the database they have, i want to be able to elegantly handle "object exists" type of errors.

 

[tlbroadbent]

Check the following topics in SQL Books Online.
[ul][li]SQLSTATE Messages
[li]ODBC Error Messages
[li]Errors Collection and Error Object[/ul]
Terry
------------------------------------
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker

 

[Cagliostro]

Are you C++ programmer? John Fill

ivfmd@mail.md

 

[Silverbeard]

No, i manage a VB shop.

Cheers for the info tlbroadbent. I now have the codes i need, and since this is a published ansi standard, i'm assuming that errors raised from Oracle will map directly to one of these so that i won't have to change my error handling depending on the database i'm deploying to.

Nuno Borges