My environment
network Novell Netware 4.1
Oracle Server 7.3.4 on NT box
Client:
Oracle ODBC Driver Oracle 7.3 Ver 2.5 2.05.0301,Win 95,
MS Driver Manager and other ODBC stuff 3.0.28.22
Aplication in VB for SQL statement execution ODBC based

Result
the script (1000 Inserts) takes two times more time with VB application
than the same script executed in SQL*PLUS environment on the same
WORKSTATION,.
Has anyone have the same expirience?

Any ideas?

Thanks in advance

Jeff Oxenhandler

First you must establish your connection to Oracle through ODBC
- that takes time it's a step that SQL*PLUS doesn't have to do already having a connection.  Second, check what kind of Cursor you are using in the CursorDriver properties(try using 1 -
rdUseODBC). Third check your ResultsetType property(try using 3
- rdOpenStatic).  Finally, if you're using a resulset use
rdOpenForwardOnly, rdConcurReadOnly.
As a last check pull the sql script out of the vb code and paste it into SQL*PLUS and run it and see if your results are the same.