How to connect FAST to Oracle from Visual Basic app ?!
From: Ad Gerrits <gerra0_at_nijmegen.nl>
Date: Tue, 27 Apr 1999 09:32:28 +0200
Message-ID: <7g3p94$glq$1_at_rubens.telebyte.nl>
I want to retrieve a just a little bit of data from an Oracle database via a Visual Basic application. I want to do this as fast as possible because it has to be done a number of times each day by a number of users. I managed to do it by writing a temporary Odbc datasourcename to the registry and then use it to connect to Oracle via Dao/Odbc. It works.... but is awfully making the connection. Because I use the connection only for 1 small query this is not acceptable.
Who knows a faster way to do this and can give some hints or example code on how to do it.
Date: Tue, 27 Apr 1999 09:32:28 +0200
Message-ID: <7g3p94$glq$1_at_rubens.telebyte.nl>
I want to retrieve a just a little bit of data from an Oracle database via a Visual Basic application. I want to do this as fast as possible because it has to be done a number of times each day by a number of users. I managed to do it by writing a temporary Odbc datasourcename to the registry and then use it to connect to Oracle via Dao/Odbc. It works.... but is awfully making the connection. Because I use the connection only for 1 small query this is not acceptable.
Who knows a faster way to do this and can give some hints or example code on how to do it.
Correct me if I'm wrong but:
- as far as I know for Vb there is no "Oracle Call Interface" or
Precompiler as for C.
- Is OracleObject for Ole a good alternative and is it (much) faster ?
- Should I migrate to Ado and use a native OleDb driver ?