Re: How to connect FAST to Oracle from Visual Basic app ?!

Ad-
You can look into the Openlink driver suite, as they provide high-performance data access through ADO/RDO VB interfaces. Visit http://www.openlinksw.com and download a free 2 user/10 connection multi-tier license today.

-Stephen
Ad Gerrits <gerra0_at_nijmegen.nl> wrote in message news: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 ?
>
>
>
>
>
>
Received on Fri Apr 30 1999 - 18:16:03 CEST