Micro Cookbook 5/COOKWORKS.BIN/odbc/oracle.txt

Text File | 1995-01-13 | 14KB | 327 lines

SETTING UP THE ODBC ORACLE DRIVER FOR USE WITH THE SQL*NET FOR WINDOWS DLLs

This file discusses how to set up the ODBC ORACLE driver to run with your
ORACLE Server software. To use the ODBC ORACLE driver with any large
application, such as Microsoft Access, you must use the SQL*Net for Windows
DLLs. Because the ODBC ORACLE driver is designed to use ORACLE Server
version 6 and the SQL*Net for Windows DLLs are designed to use ORACLE Server
version 7, you must be careful to configure your system correctly.

If you do not have the SQL*Net for Windows DLLs, or, after following the
instructions in this file, you are still unable to connect to ORACLE Server
with SQL*Net, you can contact Oracle Corp. at 1-800-345-DBMS.


If ORACLE Server version 6 is already installed on your system
--------------------------------------------------------------

To set up the ODBC ORACLE driver and the SQL*Net for Windows DLLs if you
already have ORACLE Server version 6 on your system:

1.  Make sure you have the correct versions of ORACLE products, including at
    least one SQL*Net protocol.

    Product                                  Version
    --------------------------------         -----------
    ORACLE Installer                         3.0.8.3.7
    Required Support Files                   7.0.12.1.0
    SQL*Net Named Pipes for Windows          1.1.1.3
    SQL*Net SPX for Windows                  1.1.1.5
    SQL*Net TCP/IP for Windows               1.1.7.6

2.  Test your current SQL*Net connection by using an ORACLE tool such as
    SQL*Plus for Windows.

3.  Search for and delete all copies of ORA6WIN.DLL from your system. A new
    (backwards compatible) version of ORA6WIN.DLL will be installed with the
    ODBC ORACLE driver.

4.  Run the ORACLE Installer program. When asked for your ORACLE installation
    directory, use the suggested default directory C:\ORAWIN.

5.  Run the ORACLE Installer in the ORACLE group in the Program Manager:

    a) Install the files from the Required Support Files disk.

    b) Install the SQL*Net protocol you will be using. For more information,
       see the ORACLE documentation.

6.  If the following line exists, remove it from your AUTOEXEC.BAT file:

      SET CONFIG=<oracle_configuration_file>

    Add the following line to your AUTOEXEC.BAT file:

      SET CONFIG_FILES=C:\WINDOWS\ORACLE.INI

    NOTE: If you are using the MS-DOS 6.0 operating system, add the following
    line to the end of your AUTOEXEC.BAT file:

      SET CONFIG=

    ORACLE Server first checks the CONFIG environment variable for the path of
    the ORACLE configuration file. If the CONFIG variable is not set, ORACLE
    Server checks the CONFIG_FILES variable. Because MS-DOS 6.0 can use the
    CONFIG environment variable during system startup, you must clear this
    variable before leaving your AUTOEXEC.BAT file. Otherwise, ORACLE Server
    will use its value as the path of the ORACLE configuration file.

7.  Make sure your PATH variable includes the BIN subdirectories of your
    <oraclehome> directory and the \ORAWIN directory. For example, if your
    <oraclehome> directory is C:\ORACLE6, add the following line to your
    AUTOEXEC.BAT file:

      SET PATH=%PATH%;C:\ORACLE6\BIN;C:\ORAWIN\BIN

8.  Paste the contents of your CONFIG.ORA file at the start of your
    ORACLE.INI file. For example, if your CONFIG.ORA file contains:

      LANGUAGE=American_America.US7ASCII
      ORACLE_HOME=C:\ORACLE6
      MACHINE_TYPE=J
      SQLPATH=C:\ORACLE6
      WIN_REMOTE_SESSIONS=3
      LOCAL=p:MyServer

    and your ORACLE.INI file contains:

      [Oracle]
      ORACLE_HOME=C:\ORAWIN
      LANGUAGE=American_America.US7ASCII
      NLS_LANG=ENGLISH
      WIN_LOCAL_SESSIONS=1
      TCP_VENDOR=LANMAN
      TCP_SERVICES_FILE=C:\WINDOWS\SERVICES

    then your modified ORACLE.INI file should contain:

      LANGUAGE=American_America.US7ASCII
      ORACLE_HOME=C:\ORACLE6
      MACHINE_TYPE=J
      SQLPATH=C:\ORACLE6
      WIN_REMOTE_SESSIONS=3
      LOCAL=p:MyServer

      [Oracle]
      ORACLE_HOME=C:\ORAWIN
      LANGUAGE=American_America.US7ASCII
      NLS_LANG=ENGLISH
      WIN_LOCAL_SESSIONS=1
      TCP_VENDOR=LANMAN
      TCP_SERVICES_FILE=C:\WINDOWS\SERVICES

    Note that the ORACLE_HOME variable is set twice, once to point to the
    version 6 <oraclehome> directory and once to point to C:\ORAWIN.

9.  If it is not already running, start Windows. Insert the ODBC Setup disk
    in drive A, choose Run from the Windows Program Manager (or File Manager)
    File menu, and then type "a:\setup.exe" in the Command Line box. For
    information about using the ODBC Setup program, see the online Help.

10. Run the ODBC Control Panel option and add a data source for your ORACLE
    server. For information about using the ODBC Control Panel option, see
    the online Help.

You should now be able to run the ODBC ORACLE driver. You should also be
able to run ORACLE version 6 and version 7 tools and applications written for
Windows. All of these can run over SQL*Net for Windows DLLs.

NOTE:  Due to differences in memory use, this configuration may not allow you
to run ORACLE MS-DOS-only tools or applications.


If ORACLE Server is not installed on your system
------------------------------------------------

To set up the ODBC ORACLE driver and the SQL*Net for Windows DLLs if you do not
have any versions of ORACLE Server on your system:

1.  Make sure that you have the correct versions of ORACLE products, including
    at least one SQL*Net protocol.

    Product                                  Version
    --------------------------------         -----------
    ORACLE Installer                         3.0.8.3.7
    Required Support Files                   7.0.12.1.0
    SQL*Net Named Pipes for Windows          1.1.1.3
    SQL*Net SPX for Windows                  1.1.1.5
    SQL*Net TCP/IP for Windows               1.1.7.6


2.  Install the network software connecting your client workstation to the
    server and check that a connection can be made. For example, for the
    TCP/IP protocol, type "ping <servername>". This connection must work
    before you install the SQL*Net for Windows DLLs.

3.  Run the ORACLE Installer program. When asked for your ORACLE installation
    directory, use the suggested default directory C:\ORAWIN.

4.  Run the ORACLE Installer in the ORACLE group in the Program Manager:

    a) Install the files from the Required Support Files disk.

    b) Install the SQL*Net protocol you will be using. For more information,
       see the ORACLE documentation.

5.  Add the following line to your AUTOEXEC.BAT file:

      SET CONFIG_FILES=C:\WINDOWS\ORACLE.INI

    NOTE: If you are using MS-DOS 6.0, add the following line to the end
    of your AUTOEXEC.BAT file:

      SET CONFIG=

    ORACLE Server first checks the CONFIG environment variable for the path of
    the ORACLE configuration file. If the CONFIG variable is not set, ORACLE
    Server checks the CONFIG_FILES variable. Because MS-DOS 6.0 can use the
    CONFIG environment variable during system startup, you must clear this
    variable before leaving your AUTOEXEC.BAT file. Otherwise, ORACLE Server
    will use its value as the path of the ORACLE configuration file.

6.  Make sure your PATH variable includes the C:\ORAWIN\BIN directory. To do
    this, add the following line to your AUTOEXEC.BAT file:

      SET PATH=%PATH%;C:\ORAWIN\BIN

7.  So that the ODBC ORACLE driver can use ORACLE version 7 error messages,
    copy the version 7 error messages to the directory where the ODBC
    ORACLE driver searches for error messages:

      COPY C:\ORAWIN\RDBMS70\*.MSB C:\ORAWIN\DBS

8.  Search for and delete all copies of ORA6WIN.DLL from your system. A new
    (backwards compatible) version of ORA6WIN.DLL will be installed with the
    ODBC ORACLE driver.

9.  If it is not already running, start Windows. Insert the ODBC Setup disk
    in drive A, choose