Best way to insert rows from VB to RDB?

Tom D · *nix forums Guru Joined: 28 Feb 2005 Posts: 377

Michael G. wrote:

michael@geo-da.co.il · *nix forums beginner Joined: 23 Feb 2006 Posts: 2

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

Google