Re: ODBC / OCI

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:cgeVb.239219$I06.2709895_at_attbi_s01...
>
> "Vu Pham" <vu_at_sivell.com> wrote in message
> news:c03qmo$12i0j1$1_at_ID-219297.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.
> >
> > Thanks,
> >
> > Vu
> >
> >
> If you write the code efficiently then OCI is going to be more efficient.
> Also you can use certain options that you can't use in ODBC. Of course,
you
> can write inefficient code with either API.
>
> One of the biggest mistakes is not reading the application developer's
> guides and not using bind variables. Also parse once and just keep
> reexecuting, much more efficient.

Thanks, Jim. Although I have some ODBC experience, but I would like to try OCI after reading your comment.

Vu Received on Sat Feb 07 2004 - 17:35:33 CST