From: N Prabhakar <prabhs@po.pacific.net.sg>
Subject: Re: Vb connectivity to ORACLE
Date: 1996/11/11
Message-ID: <5671aj$i3v@newton.pacific.net.sg>#1/1
references: <56671j$jh@opera.iinet.net.au>
to: G_Laslett@motherwell.com.au
content-type: text/plain; charset=us-ascii
organization: Socgen Crosby Securities
mime-version: 1.0
newsgroups: microsoft.public.vb.database,comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server
x-mailer: Mozilla 1.22KIT (Windows; I; 16bit)



G_Laslett@motherwell.com.au (Greg Laslett) wrote:
>
>We are interested in using VB as a front end/forms development
>tool to an Oracle 7 database.
>
>Are there widgets/methods available to permit direct interaction
>perhaps via SQLNET.
>
>I've heard some horror stories about trying to use ODBC as a
>connectivity layer and would prefer a simple solution that
>involves the fewest possible 'middleman' layers.
>


There is a product ORACLE*Glue, which is used with VB and even with 
Microsoft Excel. This product is quite similar to Pro*C. Oracle Glue 
directly talks to sql*net and you can use any valid SQL statements, stored 
procedures, packages and functions.

We have used ORACLE*glue with VB and the database is 7.1.6. Using Glue is 
very useful during programming because of its flexiblity over ODBC.


Regards

N.Prabhakar
Socgen Crosby Securities
Singapore