Rollback through ODBC?

We are writing a Visual Basic application that does updates against an Oracle database. The inserts are done using SQLPassthrough. The problem is that if we send a rollback command, it doesn't. We have also tried using the ODBC API calls and the same thing happens.

My theory is that Oracle is treating each statement that we send as a separate connection so the rollback is not on the same connection as the update. Any suggestions?

Andrew Radford Received on Mon Mar 18 1996 - 00:00:00 CET