William,
How do you update the remote table? If you're using an updatable view, then a TABLEREVERT() should do.

>Has anyone had this problem. I am testing my error traping one test I set up is a test that will create a unique key violation. I do this through a passthrough.
>
> I run the test I get a return of -1 and the error message says I have violated a unique key constraint, this is good.
>
> The problem is, the passthrough will not let go of the last error.
>I use a passthrough to write this error to an error table I have created, but it will not write to the table because the unique key violation is still in effect.
>
> How do I get ODBC to let go of this unique key error and use the passthrough to write this error message to my error table.