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

Michael G. wrote:
are you blocking yourself?

$rmu/sh lock/mode=block

does it have multiple connections?