VB4 ODBC Oracle/Rdb tranaction problem 
Author Message
 VB4 ODBC Oracle/Rdb tranaction problem

I have a problem updating an Oracle/Rdb database via ODBC. I can issues
a Select statement, but when I issue an update request , the SQL log shows
an error 'RDB-E.. cannot update while in a Read only transaction...The
method I am using is :

                  gDatabase.Execute "Update...", passthrough flag

I thought i could issue something like

            gDatabase.Execute "Set Transaction read write",passthrough
and then issue the update, and then commit. Alas this is not so.

How do you do transaction control in this situation???


Mon, 01 Feb 1999 03:00:00 GMT  
 VB4 ODBC Oracle/Rdb tranaction problem

Make sure that you have a primary key on the table in oracle.

Tue, 02 Feb 1999 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. VB4 Oracle/Rdb ODBC transaction problem

2. Problem with Oracle Rdb, RDO, ODBC and Dates

3. Error [08S01] [Oracle] [ODBC] [Rdb] socket () Ret 2 Err#10077 WSANOSUPPRT

4. Problems of performance with VB4 and ORACLE ODBC

5. VB4/ODBC/Oracle Problem

6. VB4 + RDO + ODBC + ORACLE = Problems?

7. VB4-32bit/Win95 Oracle ODBC problems.

8. VB4/ODBC/Oracle Problem

9. Oracle ODBC driver / Microsoft ODBC driver for Oracle

10. ADO and Oracle RDB - what data provider to use

11. 2PC Tx. with Oracle Rdb and MS SQL Server

12. Oracle Rdb to VB


Powered by phpBB® Forum Software