Sure enough, changing the statement that initializes my LCConnection object from this:

Set con = New LCConnection ( "db2" )

to this:

Set con = New LCConnection ( "odbc2" )

did the trick! Calling the LCACTION_ROLLBACK actually worked! For right now, my code just inserts additional records into the table and rolls back the transactions at the end of my code, restoring the table to its original state. I now need to update my code so that it uses LCACTION_TRUNCATE to clear the table before inserting records.

No comments.