Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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.chReceived on Sun Feb 08 2004 - 05:57:12 CST
![]() |
![]() |