Re: Oracle vs. Microsoft ODBC Driver
Date: Fri, 16 Aug 2002 17:03:38 +0100
Message-ID: <3d5d225b$0$8508$ed9e5944_at_reading.news.pipex.net>
[Quoted] "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>...
> > Newbie Question: My front end application is MS Access 2000.
> > Which is the better/most stable driver to use when accessing Oracle 9i
data?
>
> If you're going to be using a 9i Oracle client to access the data, I'd
> strongly recommend using the Oracle driver. The Microsoft driver
> hasn't been tested with the 9i client, and a number of folks on the
> Oracle Technology Network forums have reported that it doesn't work
> (i.e. won't connect). I don't believe Microsoft has any plans to fix
> this, since they haven't been working on their Oracle driver for
> years.
>
> Justin Cave
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)
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Fri Aug 16 2002 - 18:03:38 CEST