C# 2005: Getting the "message" from an SQL statement?

[TheElephantMan]

Hi, all.

I know that when I run OdbcCommand.executeNonQuery(), it returns the number of rows affected. However, is there a way to also get the error message that the database on the other end is broadcasting?

For example, if I attempt to insert a record with a primary key that already exists, I know that my rows affected will be zero. If I try to do this directly into MS Query analyzer, it tells me that I can't do it:

"Violation of PRIMARY KEY constraint '<key name>'. Cannot insert duplicate key in object '<table name'.
The statement has been terminated."

Is there a way to get messages like these through the ODBC interface in C#?

Thanks in advance,
TEM

 

[dseaver]

Have you tested running the bad query in your program? If i am not mistaken, it may throw an exception back with the Sql message. We created an API for our table, and it will throw exceptions when the query is bad, doing a command from the code should too...

 

[jmeckley]

try
{
   OdbcCommand.executeNonQuery()
}
catch(sqlexception ex)
{
   //do something with exception}
}

here are the sqlexception members

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[TheElephantMan]

Hi, all.

That's exactly what I was looking for. It's been a while since the last time I've done DB programming, so there's plenty of rust. I should have known that. :-/

Thanks for the help!
TEM