Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Client Error Handling With Ado Connection Object

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-04 : 09:12:37
Emin writes "i read here that we can capture sql server errors by ado connection.errors property and decide to use it at my error handling design.
i used the raiseerror (t-sql) command to raise custom errors at my stored procedures.
when i execute my stored procedure from sql server query analyzer it turns my errors but i cant capture it from client side...
so i couldnt get my custom errors from my client program with ado connection error property.

sql server ver: 7.0
ado ver :2.5
provider: ole

i am looking for your answer as soon as possible and thank for your interest."

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2001-12-04 : 10:33:11
Increase the severity level to 18

*************************
Just trying to get things done
Go to Top of Page

emce
Starting Member

1 Post

Posted - 2001-12-05 : 12:15:30
i already increased it to level 18.
but it doesnt effect anything

i return ado connection error object count property
and it comes still 0


Go to Top of Page
   

- Advertisement -