I am using SQLServer 6.5 as a Backend and VB 6 prof. And I am using ADO 2.1 with SQLOLEDB provider. Whenever I try to make any chages to the database and if it violates any constraint I get geneal error. " -2147217887 Errors occurred" . If I want specific error info like Primary key violation or Check constraint violation or specific error info from a trigger. How do I do that. With this general error I don't have a clue. I have used Connection objects error collection but that don't give me specific error information.

Thanks in Advance,
Anagha