Error Handling

[Roy Goldhammer]

Hello there

I have problem of using transaction on store procedure

When i running SQL store prosedure on access vb i get all there error
messages on access so i can know if the action done or not done.

Now when i started using transactions on the store procedures i don't get
the errors in access

What on the store procedure can cause this?

any help would be useful

 

[Mary Chipman]

If you're using explicit transactions in your stored procedures (BEGIN
TRANSACTION...) then you'll need to handle errors inside of the stored
procedure by trapping @@ERROR and return the information explicitly to
the client application as either output parameters or a result set.
Bear in mind that some things you might consider errors (like failure
to add a row) are not considered errors by the server, so you'll also
need to trap @@ROWCOUNT after certain operations. See SQL Server Books
Online for more information, or get a good book on writing T-SQL --
there's lots of them out there.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446