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.
>
> A high performance solution that lets the DBList DBCombo and DbGrid
> widgets interact directly with Oracle tables would be ideal.
>
> There is also talk about a product called Oracle Objects for OLE.
> Does this supply widgets like DbGrid ?
>
> Any comments from people who have already been down this
> road would be greatly appreciated.
>
> Regards,
> Greg Laslett G_Laslett_at_motherwell.com.au
> Motherwell SystemsThere is a tool provided by ORACLE itselve. It's called 0040 e.g. ORACLE
Objects For OLE. I don't know wether there is an OCX-Version, I tried the
VBX-Version. It interacts directly with the SQL-Net-drivers. It provides an
OLE-Server to establish an ORACLE-session and also an ORACLEDatacontrol that
you can bind to TrueGrids (the precedor of the DBGrid) and comboboxes. The
only diadvantage I discovered whas the lakc of performance. ODBC is much
faster. And while you only use datacontrols for browsing you can use the
SQL_PASSTHROUGH-parameter when creating dynasets and you will be as fast as
Mr. Hill.
--
M.Greß :-)
Received on Mon Nov 11 1996 - 00:00:00 CST
