Re: Oracle vs. Microsoft ODBC Driver

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3d5d225b$0$8508$ed9e5944_at_reading.news.pipex.net>...
> "Justin Cave" <jocave_at_yahoo.com> wrote in message
> news:233b7a65.0208151704.51ec9e00_at_posting.google.com...
> > bdtmike_at_hotmail.com (Mike Dwyer) wrote in message
> news:<fc2b473f.0208141614.2cee3db5_at_posting.google.com>...
>
> The MS driver 2.573.9001.00 (I think from the latest MDAC) does connect to
> both a 9.2 database and older databases when using a 9.2 client stack.
>
> Having said all that MS would undoubtedly tell you to use OLEDB instead of
> ODBC. (or even dotnet)

According to the Microsoft Knowledgebase (Q244661), they are in the process of testing their driver with the 9i client but recommend that you stay with the 8.1.7 client if you're using their driver. I misspoke when I said that it hadn't been tested, just that the testing hasn't been completed. Since updates aren't planned to their driver, it seems a bit risky to use the Microsoft driver with the 9i client. http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q244661&

Realistically, it will probably be OK simply because the 8i and 9i clients are supposed to be compatible. Since the Microsoft drivers still use the OCI 7 API calls, however, you're at the point that compatibility may start to break down.

Justin Received on Mon Aug 19 2002 - 20:35:02 CEST