Re: odbc vs native oracle using pl/sql

Hi Larry,
Here's an overview of the options there are to replace ODBC - RDO in Microsoft products. Bypasses ODBC, optimized for SQL server and Oracle
- Oracle Objects for OLE aka OO4O. Similar interface like RDO, native. Can be used in Visual C and Visual Basic
- and of course Pro*C and OCI

My experience is the ODBC environment is very unstable. Usually almost every time you install a windows product (and definitely a product with database access) the common ODBC dll's will automatically 'upgrade'. It is quite probably Oracle never has tested the conformance. I have seen situations where two different versions of the ODBC driver by Oracle were incompatible.
One statement that did work in 2.5.1.3 didn't work at all in 1.1.5. Currently I am experimenting with MS Access 97 against Oracle 8 and I can't even select a number(10,2) column correctly. Without doubt other people have similar horror stories.

Hth,

--
Sybrand Bakker, Oracle DBA

Larry Pettit <larry.pettit_at_ps.net> wrote in message news:djfz3.445$916.61690_at_news.uswest.net...
> Could someone tell me what are the advantages and disadvantages with an
odbc
> connection rather than native oracle in a client server application using
> pl/sql (stored procedures). Is performance the main reason to go native
> oracle?
>
>
Received on Wed Sep 01 1999 - 15:57:48 CDT