Re: ANSI Embedded SQL, OCI, ODBC what should I use?

OCI would be pretty much the same on all of the platforms. It has the advantage of being more flexible than Pro*C (and more readable to some).

ODBC is an option, but currently Oracle only provides ODBC drivers for Windows platforms (and soon on Linux). You can check out the Merant drivers as they seem to be decen, but they are not free. I don't know which platforms they cover, but their site should have a list.

Mark

"alederer" <alederer_at_gmx.at> wrote in message news:4059564e_at_e-post.inode.at...
> Hallo!
>
> I have an application currently using Oracle Dynamic SQL Method 4 to
> access the database.
>
> Because of new requirements which can't be handled with Oracle Dynamic
> SQL Method 4 ( unicode and LOBS), I have to rewrite the interface.
>
> But which kind of interface should I use?
>
> The interface must be available on all plattforms i need: Windows, AIX,
> Solaris, Linux.
>
> ANSI Dynamic SQL Method4 sounds that it should be not much effort to
> rewrite the current Oracle Dynamic Method 4 code.
>
> What are the advantages of OCI ?
>
> Because the application has also a ODBC db interface, this can also be a
> option. But are there all things supported via ODBC (LOBs, unicode) ? Is
> the ODBC interface of oracle available on all plattforms?
>
> Whats about the performance issues of the different interfaces?
>
> I am grateful for any information or links to further information which
> is useful to make my decision.
>
> thanks
> andreas
>
>
Received on Wed Mar 24 2004 - 15:33:55 CET