Re: Oracle ODBC Drivers

From: Oscar R. Paredes <paredes_at_ohio.edu>
Date: Fri, 1 Oct 1999 12:53:57 GMT
Message-ID: <FIxCyo.393@boss.cs.ohiou.edu>

Hello Jerome

My DB is Oracle 7.3.3.6.2 and we are going to migrate to Oracle 8.0.5 very soon, I've doing some testing with the client connectivity to calculate the impact on my clients and I found some interesting things. First of all 8.0.5 Client (SQL*Net 8) works fine with a 7.3.3 Server, however the story is not the same with ODBC. I'm folowwing these steps to install ODBC on my clients.

Install Oracle Client 8.0.5 (Options in the prompts: Oracle client - Application user)
If you have Microsoft ODBC for Oracle 2.573.2927.00, this driver should work OK, unless you have installed "Office 2000" or a non-Microsoft ODBC driver or your windows installations was not clean (upgrades from Windows 3.1 to Windows 95 or from Windows 95 to Windows 98 for example ).
If you experience problems with that driver, then use Oracle ODBC Driver 8.00.05.00, this should work OK.
If you still have problems download "Microsoft Data Access Components (MDAC - 2.1.2.4202.3)" from the Microsoft site it's free. This is the only way to correct DLL conflicts, because it removes all ODBC and OLE DB files and install new versions of these products. This MDAC version contains the Microsoft ODBC for Oracle 2.573.4202.00 (06/04/99)

The reason I prefer to try first with Microsoft Products is because they usually "get along" easily with other Microsoft Technologies.

Good Luck

Oscar R. Paredes
Oracle DBA

Administrative Systems                  (740) 593 1005 phone
316G Computer Services Center           (740) 593 0589 fax

Ohio University

Mail to: oscar.paredes_at_ohio.edu

oscar_at_paredes.com

Jerome Tytgat <> wrote in message news: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.
>
> 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'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
> 2- Is there any possible problem installing the TWO drivers one the same
> computer (odbc32 version, dll conflict, etc, etc)
>
> Thanks for helping.
>
> Jerome Tytgat
> Network Technician - Sea Informatique
> jerome.tytgat_at_sea-informatique.fr
>
>

-- Received on Fri Oct 01 1999 - 07:53:57 CDT