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 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= 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 directory. For example, if your 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 ". 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 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 " 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 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 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.