Re: Oracle ODBC Drivers

From: Corey Lawson <clawson_at_bogusucsd.edu>
Date: Fri, 1 Oct 1999 09:04:42 -0700
Message-ID: <938793838.502330@news1.ucsd.edu>

--

---

Corey Lawson
clawson_at_bogusucsd.edu
(remove the 'bogus', as it's my feeble attempt  to defeat spammer address suckers)
Jerome Tytgat wrote in message <7t1t9h$g37$1_at_jaydee.iway.fr>...
>Hello,
>
>I'm willing to know if it is possible to Install the drivers ODBC Oracle
for
>Oracle 8.0.x to connect to an Oracle 7.3.3. And if we can install this
>driver AND the driver ODBC Oracle for Oracle 7.3.3 (2.0.3.0.1) on the same
>client with NO interactions
>or problems for the software using them.

In my experience, 8.x and 7.x client software and odbc drivers can coexist peacefully (I have WinNT WS 4.0SP3, MDAC 2.1 also installed, MS Oracle ODBC driver, Oracle's Oracle v2.0, v2.5 [both for 7.x] and the 8.0 driver installed, and I haven't had any problems. One of the ODBC options that the 2.5 driver has is ASY, asynchronous fetches. ODBC is nice in that a driver will ignore what it doesn't need in the DSN, so connections on this driver work on other machines that have only the older driver.

Some of the weirdnesses I've had do deal with public synonyms, in that in some applications the public synonyms don't show as available linkable objects via ODBC...

The OpenLink (http://www.openlinksw.com) ODBC driver is faster and way more configurable than either the MS or Oracle ODBC drivers...

>
>I'll explain :
>- We have some programs which works fine with the OLD driver but we don't
>know
>how they will work with a new driver and evaluating it, is not a
possibility
>because of the wide implantation of them and the cost of these tests.
>- I'm developping under Access 97 and have some problems with this OLD one.
>I know there's a new driver ODBC for Oracle 7.3.4 (2.5.3.1.3). But i've
>looked at them and seen that it's the same files. So it's maybe not a good
>idea to install them because, maybe, we will have some problems with the
>working applications.

I use both 2.5 and 2.0 drivers with Access 97, and deploy my apps from my computer (generally use 2.5 driver) on machines with the old ones, and they work fine. The only problems I have are making sure everyone's SQL*Net config files are consistant with my definitions, as well as their ODBC DSNs...

>- I've seen that the files of the drivers for Oracle 8 are not the same
that
>the files for the drivers for Oracle 7, so i'm asking to question :
>1- can we use Oracle 8 ODBC drivers to connect to a Oracle 7.3.3 Database

Yes, you should be able to...

>2- Is there any possible problem installing the TWO drivers one the same
>computer (odbc32 version, dll conflict, etc, etc)

No, there shouldn't be, and I haven't seen any. YMMV, however...

>
>Thanks for helping.
>
>Jerome Tytgat
>Network Technician - Sea Informatique
>jerome.tytgat_at_sea-informatique.fr

-Corey Lawson
 clawson_at_spam-sucks.ucsd.edu Received on Fri Oct 01 1999 - 11:04:42 CDT