Hello!
I need to insert rows to RDB table with VB6 program. What is the best
way to do it?
I wrote a VB6 program which inserts rows into RDB table. I use ADO over
Oracle ODBC for RDB. I manage transactions using
ADODB.Connection.BeginTransaction and
ADODB.Connection.CommitTransaction. The rows are inserted by composing
SQL INSERT statement and then calling ADODB.Connection.Execute.with
SQL. It looks like:
ADODB.Connection.BeginTransaction
SQLString = "insert into table values()"
ADODB.Connection.Execute SQLString
ADODB.Connection.CommitTransaction
There is for sure only one instance of VB program which runs.
The RDB table becomes locked. I tried to play with transaction
IsolationLevel of ADO - no results.
The most sad thing is that it worked for 3 days and started to fail
afterward.
What is the problem?
TIA
MIchael
