Is there a way to talk to Oracle Server Database from VB instead of
using ODBC? What is SQL*Net?

Thanks.

Yes there is. You could write your own interface using the Oracle Call
Interface(OCI) or you could use something like Oracle Objects for OLE.
It contains a VBX data control and an OLE Server. It's not unlike the
ODBC interface(dynasets, databases,etc.)

SQL*Net is the Oracle software that you need to connect to a remote oracle
database.
The layers would be:
Your App->ODBC(maybe)->Oracle Client Lib(OCI)->SQL*Net Client->Network->
SQL*Net Server->Oracle RDBMS.

I've been using something called Oracle Glue for VB. Its fast and easy to
use. What more can you ask for?

I'm not sure where you get it from - I hadn't heard of it before.

Hope this helps,

James Shields

Call Oracle and get information about Oracle Objects.

Andrew Marshall
--
Andrew Marshall, Visual Basic junkie
Software Dynamics Consulting

72223,330 on CompuServe

Yes but you could not use the usual DAO (dynasets,...). The
thing is called Oracle object for OLE. You could have more info
on that at http:/www.oracle.com .

SQL*Net is a layer of transport over networks to be able to
connect to the database. You need on for each client
installation, but it can be used by many applications.

                Yannick

--
**********************************************************
* Yannick Skelling                                   \   *
* Analyst Programmer                                o_\  *
* Thermetrics Diagnosys Ltd.                        \__\ *

*                                                        *
*          "Be a virus, see the world."  -Gary Larson    *
**********************************************************