Re: Direct access over SQL*Net to a oracle database without ODBC from MSVC++

From: Johan Wegener <xjwegener_at_xpost.xtele.xdk>
Date: Mon, 26 Jul 1999 11:05:35 +0200
Message-ID: <7nh88r$b3p$1@news.inet.tele.dk>

Stefan Westner wrote in message =
<379b41ca.14199808_at_personalnews.de.uu.net>...
>Hello,
>
>we use Microsoft Visual C++ 6.0 to develop application for several
>databases. In general we use ODBC to access oracle 7.3 and 8.x. Are
>there any advantages to access oracle directly using sql*net's api
>without using odbc? At the moment we have to install an odbc-driver on
>every NT-machine on which our applications runs. If we could access
>oracle directly this wouldn't be longer necessary.

The main advantage is speed. On the other side, you have to install the = Oracle Client Software (SQL*Net) on each client - but if you are using = ODBC to connect to Oracle today, you have already done that.

>How could we access sql*net from our program? Are there any
>documentation available somewhere?

You can access Oracle without ODBC using the Pro*C pre-processor or by =

using the OCI library. As an application programmer, the SQL*Net/Net8 =
layer is pretty transparent. You simply connect to the database using =
"EXEC SQL CONNECT ..." (Pro*C) or "olon(...)" (OCI). After connecting =

you are able to issue SQL statements to the database server. You do not = need to get into the communication protocol details of SQL*Net/Net8.

Documentation is available on-line at the "Oracle Client" CD or at the = "Pro*C" CD.

Cheers,
Johan Received on Mon Jul 26 1999 - 04:05:35 CDT