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

Hi,

You are not programming the SQL*Net API, but the Oracle Call Interface, OCI or, with PreCompiler Embedded SQL. (Not necessarily more comfortable ;-)

you have the following advantages:
o faster access, since there is no layer in between o direct access to the Oracle SQL Language

disadvantages:
o Loss of Portability between databases.

You find the Documentation together with the development software of Oracle. (At least .pdf Files)

HTH,
        Thomas

stefan_at_westner.de (Stefan Westner) writes:

> 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.
>
> How could we access sql*net from our program? Are there any
> documentation available somewhere?
>
> Thanks
>
> Stefan Westner
Received on Tue Jul 27 1999 - 14:16:15 CEST