Re: C++ connectivity and Oracle version

On 3-Oct-2013, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On Thu, 03 Oct 2013 02:24:02 -0700, pm wrote:
>
> > Hi all,
> >
> > I currently use ODBC and my app actually can connect to different Oracle
> > versions (9, 10, 11).
> >
> > Do OCI or OCCI require a compilation for each Oracle/OCI/OCCI version?
> >
> > Thanks pm
>
> No. Connection through ODBC driver only requires working ODBC driver. If
> the library is ODBC compliant, it has a set of calls defined by the ODBC
> standard, and can be substituted, regardless of version.

Although I would note that if a program is written in C/C++, it should never use ODBC. There is simply no good reason for that. I'll grant that writing OCI code can be a challenge, but OLEDB is easy to use and is the preferred alternative to ODBC. The days of ODBC being separate from OLEDB are long gone. At this point ODBC is essentually just a translation layer that sits on top of OLEDB. So why have the extra layer. Learning how to make OLEDB calls is simple and there are no convolutions such as those that sometimes must be used with ODBC to use things like 'fn ......" or curley braces around some expressions. I haven't written ODBC code for years because I've never found a situation where ODBC works better than OLEDB. Received on Thu Oct 03 2013 - 17:55:09 CEST