Recommended OleDB driver for Oracle?

Hi,

I'm looking into converting a fairly complex application from using ODBC
drivers to OLEDB drivers. Judging from some errors I get when just
substituting the connection strings I have to do some reprogramming.
However, I get a different set of errors from the Microsoft OleDB For Oracle
driver than I get from the Oracle OleDB Driver.

Normally I would opt for the drivers from the DBMS vendor but my experience
with Oracle ODBC drivers is that they tend to break between releases (both
major and minor). I have been using the Microsoft ODBC for Oracle driver for
years and have never had any problems except that it did not support past
Oracle 8 (looks like the current version does but I'm still checking).

Does anyone have any recommendations about whether to go with Microsoft's
OleDB driver or Oracle's?

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

Re: Recommended OleDB driver for Oracle?

The one thing we found when testing the OLE DB drives for Oracle was with
stored procedures that returned a recordset. the command object needed one
more parameter set:

DB_Command.Properties("PLSQLRSet") = TRUE

There were other differences, such as the inablility to globally set the
default date format for the connection.

Marshall Gates

"Mark Schupp" wrote in message
news:eF%23hOuxAFHA.4072@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I'm looking into converting a fairly complex application from using ODBC
> drivers to OLEDB drivers. Judging from some errors I get when just
> substituting the connection strings I have to do some reprogramming.
> However, I get a different set of errors from the Microsoft OleDB For
Oracle
> driver than I get from the Oracle OleDB Driver.
>
> Normally I would opt for the drivers from the DBMS vendor but my
experience
> with Oracle ODBC drivers is that they tend to break between releases (both
> major and minor). I have been using the Microsoft ODBC for Oracle driver
for
> years and have never had any problems except that it did not support past
> Oracle 8 (looks like the current version does but I'm still checking).
>
> Does anyone have any recommendations about whether to go with Microsoft's
> OleDB driver or Oracle's?
>
> --
> --Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
>