Re: 32Bit ODBC driver for Oraclev7.1

From: Andreas Habl <andreas.habl_at_europemail.com>
Date: 1998/02/08
Message-ID: <01bd3479$c972e800$0100007f_at_meine-kiste>


Frank Huijbreghs <frankhu_at_wxs.nl> schrieb im Beitrag <6bic91$8nc1_at_reader2.wxs.nl>...
> Hi folks,
>
> We are using a Oracle V7.1.4.3.2 Database on a Novell 3.12 server.
> Under Windows 3.11 we use the Oracle ODBC 1.11.0.2 to retrieve data from
 the
> Oracle database to Microsoft Excel but now we want to/must use Excel97
 under
> Windows95.
>
> I know that I have to use the 32bit ODBC driver but I don't know which
> version (SQL*Net & ODBC) I sould use.
> I've tried several versions but without success.
>
> Does somebody know how I can connect Ecxel97 to Oracle V7.1
> Please help me!!
>
> Many thanks in advance.
>
> ( Please post a copy of your reply to frankhu_at_wxs.nl )
>
> F. Huijbreghs
> Email: frankhu_at_wxs.nl
>
>
>
>
WIN/NT/95: SUPPORTED ODBC CONFIGURATIONS Document ID: 11118004.61

Title: WIN/NT/95: SUPPORTED ODBC CONFIGURATIONS

Product: Oracle7 ODBC driver

Product Version: Generic

Platform: Windows, Windows NT, Windows 95

Information Type: ADVISORY

Impact: HIGH

Abstract: This bulletin lists the versions of ODBC drivers that   are available on Windows 3.1, Windows NT and Windows 95.   and discusses the SQL*Net and Required Support Files   dependency.

Keywords: ODBC; Oracle7;datasource;SQL*Net;RSF;   Connection


WIN/NT/95: SUPPORTED ODBC CONFIGURATIONS The ODBC (Open Database Connectivity) interface allows applications to access data in DBMS ( Database management systems) using SQL(structured query language). Oracle ODBC driver is a DLL that implements ODBC function

calls and interacts with a data source.

The flow of control when communicating from an application through ODBC to Oracle database is as shown below.

                                    Application
                                         |
                                 ODBC driver manager
                                         |
                                 Oracle7 ODBC Driver
                                         |
                                       OCI layer
                                         |
                                     SQL*Net Driver
                                         |
                                     Network Software
                     ( PCTCP, Novell NetWare, Microsoft LAN Manager, etc,.)
                                         |
                                   SQL*Net Listener
                                         |
                                     Oracle7 RDBMS




When a third party application communicates with the Oracle database in a Client/Server environment, several dynamic link libraries are involved. ODBC driver is a DLL that implements ODBC function calls. The ODBC driver communicates with the OCI layer. The DLLs used in the OCI layer are part of
Required Support Files. Required Support Files are bundled with SQL*Net. Each version of the ODBC driver is linked with a specific version of RSF. Each version of SQL*Net is also dependent on a specific version of RSF. The matrix below shows the dependency.



-

ODBC driver| 16/32| Supported | Supported | RSF version | RDBMS version | bit | Platforms | SQL*NET ver| used | version



-
1.11.00.05 | 16   | Windows    | 2.0.X      | 7.0.X       | 7.0
           | bit  |  3.1X      | for Windows|             |
           |      |            |            |             |
----------------------------------------------------------------------------
-
1.11.01.05 | 16   | Windows    | 2.1.X      | 7.1.X       | 7.1
           | bit  |  3.1X      | for Windows|             |
----------------------------------------------------------------------------
-
1.14.01.00 | 16   | Windows    | 2.2.X      | 7.2.X       | 7.2
           | bit  |  3.1X      | for Windows|             |
----------------------------------------------------------------------------
-
1.15.3.0.1A| 16   | Windows    | 2.3.X      | 7.3.X       | 7.3
           | bit  |  3.1X      | for Windows|             |
----------------------------------------------------------------------------
-
1.15.3.1   | 16   | Windows    | 2.3.X      | 7.3.2.1.1   | 7.3
           | bit  |  3.1X      | for Windows|             |
----------------------------------------------------------------------------
-
1.16.3.1A  | 16   | Windows    | 2.3.X      | 7.3.2.1.1   | 7.3
           | bit  |  3.1X      | for Windows| or later    |
----------------------------------------------------------------------------
-
2.0.0.3.1.1| 16   | Windows    | 2.3.X      | 7.3.2.1.1   | 7.3
           | bit  |  3.1X      | for Windows| or later    |
----------------------------------------------------------------------------
-
1.13.05.00 | 32   | Windows NT | 2.2.X      | 7.2.X       | 7.2
           | bit  | 3.1/3.51   | (32-bit)~~ |             |
           |      | and        |            |             |
           |      | Windows95  |            |             |
----------------------------------------------------------------------------
-
1.13.05.04 | 32   | Windows NT | 2.2.X      | 7.2.X       | 7.2
           | bit  | 3.1/3.51   | (32-bit)~~ |             |
           |      | and        |            |             |
           |      | Windows95  |            |             |
----------------------------------------------------------------------------
-
1.15.3.0.1A| 32   | Windows NT | 2.3.X      | 7.3.X       | 7.3
           | bit  | 3.1/3.51   | (32-bit)~~ |             |
           |      | and        |            |             |
           |      | Windows95  |            |             |
----------------------------------------------------------------------------
-
1.15.3.1   | 32   | Windows NT | 2.3.X      | 7.3.X       | 7.3
           | bit  | 3.1/3.51   | (32-bit)~~ |             |
           |      | and        |            |             |
           |      | Windows95  |            |             |
----------------------------------------------------------------------------
-
1.16.3.1.0A| 32   | Windows NT | 2.3.X      | 7.3.2.1.1   | 7.3
           | bit  | 4.0 and    | (32-bit)~~ | or later    |
           |      | Windows95  |            |             |
----------------------------------------------------------------------------
-
2.0.0.3.1.1| 32   | Windows NT | 2.3.X      | 7.3.2.1.1   | 7.3
           | bit  | 4.0 and    | (32-bit)~~ | or later    |
           |      | Windows95  |            |             |
----------------------------------------------------------------------------
-

~~ : You must use SQL*Net for Windows NT, if you are running your application

     on Windows NT. If you are running your application on Windows 95, you
     must use SQL*Net for Windows 95.

NOTES:


If you are running an ODBC driver not listed in the above matrix, we strongly
recommend that you upgrade your ODBC driver.

Basics:



If your application is a 32-bit application, you must use 32-bit Oracle ODBC
driver and 32-bit SQL*Net for the platform, your application is targeted. For a 16-bit application, you must use 16-bit Oracle ODBC driver along with SQL*Net for Windows(16-bit).

SQL*Net Version 1.X



If you are using SQL*Net Version 1.X, your connection should work against 7.2
or older Oracle databases. SQL*Net Version 1.X was de-supported June 30, 1996. We recommend that you upgrade your SQL*Net.

Connecting to Standalone Personal Oracle Database:



If you connect to a local, standalone Personal Oracle database, you will use
a two-task driver ( In the above flow chart the two-task driver will replace
SQL*Net). The connect string is 2: where is the instance ID. The default SID is ORCL. (no period)

ODBC Documentation:



The Oracle7 ODBC driver comes with on-line help. The help file name is DRVORA7*.HLP * could take values NULL, 1, or 2 depending upon the version of
the Oracle ODBC driver installed.

For ODBC API documentation, refer ODBC 2.0 Programmer's Reference and SDK Guide from Microsoft Press. The online version of ODBC 2.0 Programmer's Reference and SDK guide is part of MSVC++ compiler.

Version of Oracle product: How to find ?



To find the versions of Oracle software installed on your machine run the Oracle installer (ORAINST.EXE). In case of errors, versions numbers are an important part of problem definition.

Common ODBC Q&A



Q. I have two ODBC drivers, 1.11.0.5.0 and 1.11.1.5.0. Which driver should I

   install?

  1. The version of the ODBC driver you will install is dependent on the Required Support Files (RSF) you have on your system. If you are running RSF 7.0.X, you need to install 1.11.5.0. If you are running RSF 7.1X, you need to install 1.11.1.5.0.

   You can find the RSF version by running ORAINST.EXE, the Oracle installer.

   When ORAINST.EXE is run the Software Asset Manager displays the products    available to install as well as those products already installed. Search

   for the Required Support File and make note of the version.

Q. What other products do I need so that the ODBC driver works?

  1. You definitely need the appropriate SQL*Net version (16-bit or 32-bit). Make sure that SQL*Net is installed and configured correctly before you try to connect through ODBC. For example, if you are using 32-bit ODBC driver for Windows 95, and TCP/IP is your protocol, you must have SQL*Net for Windows 95 (TCP/IP) installed and configured, before you can make a connection through ODBC.

   Note: If you are connecting to a standalone Personal Oracle7 for

         MS Windows, you do not need SQL*Net.  Personal Oracle7 uses a two
         task driver - SQL2TT.dll to connect to its standalone database.

         32-bit ODBC driver required 32-bit SQL*Net and
         16-bit ODBC driver requires 16-bit SQL*Net.

   You also need the appropriate version of Required Support Files installed

   on your system.

General Suggestions:



Please read the release notes and the online documentation. They contain important information.

In case of error, please write down the entire error message as seen on the monitor(screen). An error message is key in finding the problem.

Where can I get Oracle ODBC drivers?



The Oracle ODBC drivers are available as free products on the world-wide web.
The URL is http://www.oracle.com/ Received on Sun Feb 08 1998 - 00:00:00 CET

Original text of this message