Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC / OCI

Re: ODBC / OCI

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 8 Feb 2004 11:57:12 GMT
Message-ID: <c0586n$12gel2$1@ID-82536.news.uni-berlin.de>

> 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
Received on Sun Feb 08 2004 - 05:57:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US