Re: Using VB as a front end to Oracle

You can use Oracle Objects 4 OLE. (from Oracle)

It is a layer on top of sql*net.

I don't have any speed comparisons. But you do everything in native oracle sql or plsql.

It supports it own implimentation of dynasets etc.

The nice thing is you skip ODBC altogther. But watch out for interactions with other program or products.

On Wed, 18 Dec 1996 17:33:44 -0500, Gordon Mechan <mechang_at_fl.logica.com> wrote:

>I need to investigate using VB as a front end GUI client to Oracle.
>What I would like to know is what is the best performance method of
>interfacing VB to Oracle. VB allows the use of a data control, DAO (and
>JET), RDO or by using the ODBC API. Because performance is an issue,
>ODBC seems the best bet. However, is there a more direct approach to
>interfacing VB to Oracle than using ODBC?
>
>What about SQLnet? Will this work with VB and give better performance if
>possible?
>
>VB wouldn't be my first choice to interface to Oracle, but the client
>has a wish to use it, unless there is good arguments for using another
>front end tool. Any suggestions in that area?
>
>Thanks
>
>Gordon Mechan

--
Kalman Skulski              Kal_Skulski_at_mindlink.bc.ca
Western Software Solutions  V:(604) 589-9066
#202-10090 152nd Street     F:(604) 589-0725
Surrey, BC