home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Programming Tool Box
/
SIMS_2.iso
/
vb_code2
/
string
/
sample.txt
< prev
next >
Wrap
Text File
|
1994-07-15
|
12KB
|
270 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
RDBMS 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 RDBMS version 6 and the
SQL*Net for Windows DLLs are designed to use ORACLE RDBMS version 7, you must
be careful to configure your system correctly.
ORACLE RDBMS 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 RDBMS version 6 on your system:
1. Make sure that you have the correct versions of products from Oracle,
including at least one SQL*Net protocol.
Product Version
-------------------------------- -----------
Oracle Installer 3.0.8.3.6
Required Support Files 7.0.10.5.0
SQL*Net SPX for Windows 1.1.1.3
SQL*Net TCP/IP for Windows 1.1.7.5
SQL*Net Named Pipes for Windows (Not in production yet)
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 your <Oracle-home> directory (usually C:\ORACLE6) instead of
the suggested default directory (C:\ORAWIN).
5. Run the Oracle installer that was placed 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 it exists, remove the following line 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 (currently in Beta
release), add the following line to the end of your AUTOEXEC.BAT file:
SET CONFIG=
ORACLE RDBMS first checks the CONFIG environment variable for the path of
the Oracle configuration file. If the CONFIG variable is not set, it
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 RDBMS will use its
value as the path of the Oracle configuration file.
7. Make sure your PATH variable includes the BIN subdirectory of your
<Oracle-home> directory. For example, if your <Oracle-home> directory is
C:\ORACLE6, add the following line to your AUTOEXEC.BAT file:
SET PATH=%PATH%;C:\ORACLE6\BIN
8. If it is not already running, start Windows. Insert the ODBC setup disk
in drive A: and run A:\SETUP.EXE (either through the Run menu item in the
File menu in Program Manager or through File Manager). For information
about using the ODBC setup program, see the online help.
9. 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 that have been
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 DOS-only tools or applications.
ORACLE RDBMS 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 RDBMS on your system:
1. Make sure that you have the correct versions of products from Oracle,
including at least one SQL*Net protocol.
Product Version
-------------------------------- -----------
Oracle Installer 3.0.8.3.6
Required Support Files 7.0.10.5.0
SQL*Net SPX for Windows 1.1.1.3
SQL*Net TCP/IP for Windows 1.1.7.5
SQL*Net Named Pipes for Windows (Not in production yet)
2. Install the network software connecting your client workstation to the
server computer and check that a connection can be made. For example,
for the TCP/IP protocol, type "PING <server>". 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 that was placed 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 the MS-DOS 6.0 operating system (currently in Beta
release), add the following line to the end of your AUTOEXEC.BAT file:
SET CONFIG=
ORACLE RDBMS first checks the CONFIG environment variable for the path of
the Oracle configuration file. If the CONFIG variable is not set, it
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 RDBMS 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:\ORACLE6\BIN
7. So that the ODBC ORACLE driver will be able to use Oracle version 7 error
messages, copy the version 7 error messages to the directory where the ODBC
ORACLE driver will search 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: and run A:\SETUP.EXE (either through the Run menu item in the
File menu in Program Manager or through File Manager). 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.
ORACLE Error Messages
---------------------
The following section explains what to do when you encounter various error
messages from ORACLE RDBMS through the ODBC ORACLE driver.
ORA-xxxxx Message not found; product=RDBMS; facility=ORA; language=NULL
-------------------------------------------------------------------------
The ODBC ORACLE driver searches for error messages in the subdirectory that
normally contains the ORACLE version 6 error messages. If you receive this
error, it means that the ODBC ORACLE driver cannot find the error messages.
To fix this:
1. Check that the CONFIG_FILES variable is set in your AUTOEXEC.BAT file and
that it points to your Oracle configuration file (ORACLE.INI). If you are
using the MS-DOS 6.0 operating system (currently in Beta release), check
that the CONFIG environment variable is either not set or is cleared in the
last line of your AUTOEXEC.BAT file.
2. Check that the ORACLE_HOME variable in your Oracle configuration file
points to your <Oracle-home> directory. If you already had ORACLE RDBMS
version 6 installed on your system, this will usually be C:\ORACLE6. If
you did not have a version of ORACLE RDBMS on your system, this will be
C:\ORAWIN.
3. If you did not have any Oracle software on your workstation, make sure
that you copied the *.MSB files from C:\ORAWIN\RDBMS70 to C:\ORAWIN\DBS.
The ODBC ORACLE driver should now be able to print the ORACLE RDBMS error
message, allowing you to fix the problem that generated the error.
ORA-03121 no interface driver connected - function not performed
-----------------------------------------------------------------
The ODBC ORACLE driver cannot find ORA6WIN.DLL or on of the SQL*Net components.
Check the following:
1. Without the ODBC ORACLE driver running, make sure that the network
connection is valid. For example, type "PING <server>" for a TCP/IP
connection.
2. Search for and delete old versions of ORA6WIN.DLL. The correct version of
the ORA6WIN.DLL was installed by the ODBC ORACLE driver in the SYSTEM
subdirectory of your Windows directory.
3. Check that the PATH variable contains the BIN subdirectory of the
<Oracle-home> directory (usually C:\ORACLE6\BIN or C:\ORAWIN\BIN).
4. Check that the CONFIG_FILES variable is set in your AUTOEXEC.BAT file and
that it points to your Oracle configuration file (ORACLE.INI). If you are
using the MS-DOS 6.0 operating system (currently in Beta release), check
that the CONFIG environment variable is either not set or is cleared in the
last line of your AUTOEXEC.BAT file.
5. Check that SQLTCP.DLL (for TCP/IP), SQLSPX.DLL (for Novell NetWare IPX/SPX),
or SQLNMP.DLL (for Named Pipes) is in the Oracle BIN directory specified in
the PATH variable. (If not, SQL*Net was not installed correctly.)
6. Check that ORA7WIN.DLL and COREWIN.DLL are in the Oracle BIN directory
specified in the PATH variable. (If not, SQL*Net was not installed
correctly.)
ORA-06120 NETTCP: network driver not loaded
--------------------------------------------
This error can occur when ORA6WIN.DLL is loaded but it cannot find another
SQL*Net component, such as SQLTCP.DLL.
1. Check that the directories containing the SQL*Net components are in your
PATH variable.
2. Check that the ORACLE_HOME variable in your Oracle configuration file
points to your <Oracle-home> directory. If you already had ORACLE RDBMS
version 6 installed on your system, this will usually be C:\ORACLE6. If
you did not have a version of ORACLE RDBMS on your system, this will be
C:\ORAWIN.
3. Search for and delete old versions of ORA6WIN.DLL. The correct version of
the ORA6WIN.DLL was installed by the ODBC ORACLE driver in the SYSTEM
subdirectory of your Windows directory.
4. Check that you have followed all the instructions for the SQL*Net driver
you are using. For example, for the SQL*Net for TCP/IP driver, make sure
the all the TSRs are loaded (such as NMTSR and SOCKTSR). (If not, SQL*Net
was not installed correctly.)
ODBC Error Messages
-------------------
IM003 Driver specified by data source could not be loaded
The ODBC Driver Manager is attempting to load the ODBC ORACLE driver
(SQORA.DLL). SQORA.DLL loads ORA6WIN.DLL to connect to the Oracle server.
You can receive this message it cannot find ORA6WIN.DLL or finds the wrong
version of ORA6WIN.DLL.
1. Search for and delete old versions of ORA6WIN.DLL. The correct version of
the ORA6WIN.DLL was installed by the ODBC ORACLE driver in the SYSTEM
subdirectory of your Windows directory.
2. Make sure that ORA6WIN.DLL was installed when the ODBC ORACLE driver was
installed.