Oracle & VB..Help Help Help.......

[b][red]This message was edited by venkatna at 2002-8-23 6:45:36[/red][/b][hr]
ORA-03114: not connected to ORACLE.

Iam trying to insert records one by one from VB to a table in Oracle database.
Here is the code sample
do while <>
lstrInsertSql = "Insert into employee Values(" & lstrInsertValues & ")"
Set lobjCommand = New ADODB.Command
lobjCommand.ActiveConnection = gobjADOProcess.mobjADO.FullConnect
Set lobjRS = gobjADOProcess.mobjADO.OpenRSDisconnected(lstrInsertSql)
lobjCommand.CommandText = lstrInsertSql
Set lobjCommand = Nothing

Half way thru.... after inserting approx. 20,000 records, I get this error message
ORA-03114: not connected to ORACLE.

Please let me know how to handle large volume of data.
Please help.
Thanks in advance
ORA-03114: not connected to ORACLE.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!