Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Location
    Munich, Germany
    Posts
    1

    Exclamation Unanswered: RAISERROR passing to MS ACCESS

    Hi,

    I'm trying to pass an error code from a MSSQL 6.5 database trigger to ms access 97, but can't get it work.

    The code part that raises the error is:

    RAISERROR (153,16,-1)

    I also tried RAISERROR ("someerrordescriptionhere",16,-1).

    When inserting a new recordset into the table, the trigger checks the biz rules. if the recordset infringes the biz rules, an error should be passed to access. However, access doesn't even recognize the error, although - when inserting with the sql query tool from sql 6.5, the error msg is being raised properly.

    Thanks in advance,

    Tom

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •