by George Pujol - gpujol@interserv.com

Contents

• TNS Client Files
  • Samples for Connecting to Netware Server
  • Samples for Connecting to Windows NT Server
• TCP/IP Client Files
• BDE Setup
  • Oracle Driver Setup
  • Oracle Alias Setup
• ODBC Setup
  • ODBC Driver Setup
  • ODBC Alias Setup
• Additional Client Files for 16-bit Oracle Applications
• Required 16-bit Oracle Files for connecting to your Oracle Workgroup Server
• Required 16-bit ODBC Files for connecting to your Oracle Workgroup Server
• Required 16-bit Oracle Files for connecting to Personal Oracle 7.1 and Personal Oracle for Windows95

Samples for Connecting to Netware Server

TNSNAMES.ORA (SPX Protocol)

ORACLE=(DESCRIPTION=
          (ADDRESS_LIST=
             (ADDRESS=
                (PROTOCOL=SPX)
                (SERVICE=ORASRV)
             )
          )
          (CONNECT_DATA=(SID=ORCL)) # SID value cannot exceed four characters
       )

ORACLE=(DESCRIPTION=
          (ADDRESS_LIST=
             (ADDRESS=
                (PROTOCOL=TCP)
                (HOST=ORAC) # You can optionally specify an IP address here (i.e., 192.2.3.9)
                (PORT=1521)
             )
          )
          (CONNECT_DATA=(SID=ORCL)) # SID value is limited to four characters
       )

AUTOMATIC_IPC = OFF
SQLNET.EXPIRE_TIME = 2147483647
trace_level_client = [off | 16]
trace_file_client = sqlnet
trace_directory_client = G:\ORANW7x\network\trace
log_file_client = sqlnet
log_directory_client = G:\ORANW7x\network\log

Samples for Connecting to Windows NT Server

The TNS files should be mostly identical to the ones in the previous section, with the exception of

TNSNAMES.ORA (Named Pipes Protocol)

ORACLE=(DESCRIPTION=
          (ADDRESS_LIST=
             (ADDRESS=
                (PROTOCOL=NMP)
                (Server=NTSERVER)
                (Pipe=ORAPIPE)
             )
          )
          (CONNECT_DATA=(SID=ORCL)) # SID value is limited to four characters
       )

If you are using TCP/IP, you should also define the following entries in your Windows workstation. It is strongly recommended that you setup your TCP/IP network first and see if you are able to use the basic TCP/IP utilities for communicating between your workstation and the server (i.e. Ping).

Only after having a working TCP/IP configuration should you try to connect to your database using BDE and SQL*Net.

(Note that the following entries duplicate the ones you have already defined on the server).

HOSTS

192.2.3.9   orac # an arbitrary IP address.

orac 1521/tcp oracle   # Oracle recommends setting this port to either 1521 or 1527

Oracle Driver Setup

Driver Name: ORACLE
Parameters:

VERSION	1.0
TYPE	SERVER
DLL	SQLD_ORA.DLL
VENDOR INIT	ORA7xWIN.DLL
DRIVER FLAGS
SERVER NAME
USER NAME
NET PROTOCOL
OPEN MODE	READ/WRITE
SCHEMA CACHE SIZE	8
LANGDRIVER
SQLQRYMODE	SQLD_ORA.DLL
SQLPASSTHRU MODE	SHARED AUTOCOMMIT
SCHEMA CACHE TIME	-1

Comments:
1) The "SERVER NAME" value can be set either at the driver or alias level. Notice that the alias will override any value you have set for the driver (See also comment in section 4.3.2).
2) Required parameters for establishing connection are shown in boldface style.

Oracle Alias Setup

Alias Name: ORACLE
Parameters:

TYPE	ORACLE
PATH
SERVER NAME	ORACLE
USER NAME	(See comment #3)
NET PROTOCOL
OPEN MODE	READ/WRITE
SCHEMA CACHE SIZE	8
LANGDRIVER
SQLQRYMODE
SQLPASSTHRU MODE

Comments:
1) The "SERVER NAME" value must be identical to the alias name defined in TNSNAMES.ORA (ORACLE in this example).
2) Required parameters for establishing connection are shown in boldface style.
3) Enter your user name here (sys, system, scott, etc.)

ODBC Driver Setup

Driver Name: ODBC_ORA7316
Parameters:

VERSION	1.0
TYPE	SERVER
DLL	IDODBC01.DLL
ODBC DRIVER	Oracle73
DRIVER FLAGS
USER NAME
ODBC DSN	ORA73_ODBC
OPEN MODE	READ/WRITE
SCHEMA CACHE SIZE	8
SQLQRYMODE
LANGDRIVER
SQLPASSTHRU MODE

ODBC Alias Setup

Alias Name: ORA7316_ODBC
Parameters:

TYPE	ODBC_ORA7316
PATH
USER NAME
ODBC DSN	ORA73_ODBC
OPEN MODE	READ/WRITE
SCHEMA CACHE SIZE	8
SQLQRYMODE
LANGDRIVER
SQLPASSTHRU MODE

WIN.INI file

Make sure the following section exists in your WIN.INI file:

[Oracle]
ORA_CONFIG=path to your ORACLE.INI file (i.e., D:\WINNT351\ORACLE.INI).

Verify that your ORACLE.INI file contains the following entries (which should match the corresponding server values in your CONFIG.ORA file if connecting to an Oracle Workgroup Server for Netware or your "Oracle" Registry Key if connecting to an Oracle Workgroup Server for NT):

ORACLE.INI FOR NETWARE

[Oracle]
NET2x=G:\ORANW7x\NETWORK
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_HOME=G:\ ORANW7x
ORACLE_SRVNAME=ORACLE
ORAINST=G:\ORANW7x\dbs
ORA_SQLDBA_MODE=LINE
OS_NAME=netware
RDBMS7x=G:\ORANW7x\RDBMS7x
SQLPATH=G:\PUBLIC\O7WS_CLI\dbs
; The next entries are only needed if you are connecting through TCP/IP.
TCP_PORT=1525
TCP_VENDOR=WINSOCK
TCP_HOSTS_FILE=F:\ETC\HOSTS
TCP_SERVICES_FILE=F:\ETC\SERVICES

[Oracle]
ORACLE_HOME=P:\PUBLIC\ORANT7x
ORACLE_SID=orcl
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORA_ORCL_PWFILE=P:\PUBLIC\ORANT7x\RDBMS7x\PWDORCL.ORA
ORAINST=P:\PUBLIC\ORANT7x\dbs
ORACLE_SRVNAME=ORACLE
ORA_SQLDBA_MODE=LINE
ORACLE_PRIORITY=CLASS:normal;DEF:normal
RDBMS7x=P:\PUBLIC\ORANT7x\RDBMS7x
RDBMS_FILES=P:\PUBLIC\ORANT7x\DATABASE
NET2x=P:\PUBLIC\ORANT7x\NETWORK
; The next entries are only needed if you are connecting through TCP/IP (very likely).
TCP_PORT=1527
TCP_VENDOR=WINSOCK
TCP_HOSTS_FILE=D:\WINNT351\SYSTEM32\DRIVERS\ETC\HOSTS
TCP_SERVICES_FILE=D:\WINNT351\SYSTEM32\DRIVERS\ETC\SERVICES

[ODBC Data Sources]
ORA73_ODBC=Oracle73

[ODBC Drivers]
Oracle73=Installed

Orahelp=C:\ORANT73\odbc\drvora73.hlp

VSL.INI file (if using TCP/IP)

This file must exist in your Windows directory. It sets several TCP/IP parameters needed for your connection.

If you are unable to connect to your database, make sure that the following files reside in a searchable directory (i.e. C:\ORAWIN\BIN) in your path. Make sure that you have only one copy of these files:

	ORACLE 7.1	ORACLE 7.2	ORACLE 7.3	COMMON
Main modules:	ORA71WIN.DLL	ORA72WIN.DLL	ORA73WIN.DLL
	CORE3WIN.DLL	C3LXWIN.DLL	COR35WIN.DLL
	NLS23WIN.DLL	NLS3WIN.DLL	NLS32WIN.DLL
	USDMEM.DLL	USDMEM.DLL	USDMEM.DLL
TNS modules:	SNS.DLL	SNS.DLL	NASNS.DLL
			LIBNCR.DLL
				SQLTNS.DLL
				NL.DLL
				NT.DLL
				NS.DLL
SPX modules:				NTS.DLL
TCP/IP modules:				NTT.DLL
NMP modules:				NTN.DLL

As already mentioned, this configuration uses the Oracle7 ODBC driver Version 1.15.3.0.1a for SQL*Net 2.3.

The following files must reside in your Windows System directory:

ODBC.DLL, ODBCINST.DLL

SQORA73N.DLL

Personal Oracle 7.1 uses the same client files as OWS 7.1 does, and Personal Oracle for Windows95 uses the OWS 7.2 set.

First Page
Server Setup
Multiple Server Connections