Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 32Bit ODBC driver for Oraclev7.1

Re: 32Bit ODBC driver for Oraclev7.1

From: Andreas Habl <andreas.habl_at_europemail.com>
Date: 1998/02/08
Message-ID: <01bd3479$c972e800$0100007f@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 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US