Re: ODBC / OCI

> Hi all,
>
> I am sorry if this question is so simple or has been answered somewhere. I
> did some Google search but maybe I did'nt use the correct keywords.
>
> I am looking for the benefit comparison between using ODBC or OCI to connect
> to a remote Oracle server. The platform for the app is W2k.

ODBC is built upon OCI, that is ODBC uses OCI to communicate with Oracle Server.

The advantage of ODBC is: once you know its API, you can use the same API for all database products that have an ODBC layer. The disadvantage of ODBC is: it doesn't support the whole possibilities that OCI gives you.

An advantage of OCI is: it can be compiled on Unix as well as Windows. (Which might not be very important in your case).

I have tried to do some basic OCI stuff once and have put the result on my web page, if you're interested it's here:

    http://www.adp-gmbh.ch/ora/misc/oci/

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch