Connecting Borland Database Engine applications to Oracle Workgroup Server 7 (Updated for Oracle 8)

by George Pujol - gpujol@interserv.com

Client Setup (32-bit)

Contents

TNS Client Files

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
       )
TNSNAMES.ORA (TCP/IP Protocol) 
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
       )
SQLNET.ORA 
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
Note: drive G: maps to volume APPVOL1: in this example.

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
       )
Also, the SQLNET.ORA file would have different subdirectory values for the directory_client entries.

TCP/IP Client Files

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.
SERVICES 
orac 1521/tcp oracle # Oracle recommends setting this port to either 1521 or 1527
BDE Setup

Oracle Driver Setup

Driver Name: ORACLE
Parameters: 
BATCH COUNT
 
200
 
BLOB SIZE
 
32
 
BLOBS TO CACHE
 
64
 
ENABLE BCD
 
FALSE
 
ENABLE INTEGERS
 
FALSE
 
ENABLE SCHEMA CACHE
 
FALSE
 
DLL
 
SQLD_ORA.DLL
 
DLL32
 
(See comment #2)
 
DRIVER FLAGS
   
LANGDRIVER
   
LIST SYNONYMS
 
NONE
 
MAX ROWS
 
-1
 
NET PROTOCOL
   
OPEN MODE
 
READ/WRITE
 
ROWSET SIZE
 
20
 
SCHEMA CACHE DIR
   
SCHEMA CACHE SIZE
 
8
 
SCHEMA CACHE TIME
 
-1
 
SERVER NAME
   
SQLPASSTHRU MODE
 
SHARED AUTOCOMMIT
 
SQLQRYMODE
 
READ/WRITE
 
TRACE MODE
 
0
 
TYPE
 
SERVER
 
USER NAME
   
VENDOR INIT
 
(See comment #3)
 
VERSION
 
3.0

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) Set to SQLORA32.DLL for Oracle 7 and to SQLORA8.DLL for Oracle 8.
3) Set to ORANT71.DLL, ORA72.DLL, ORA73.DLL, or ORA805.DLL depending on Oracle Client version.
4) Required parameters for establishing connection are shown in boldface style.

Oracle Alias Setup

Alias Name: ORACLE
Parameters: 
TYPE 
 
ORACLE
 
BATCH COUNT
   
ENABLE BCD
 
FALSE
 
ENABLE INTEGERS
 
FALSE
 
ENABLE SCHEMA CACHE
 
FALSE
 
LANGDRIVER 
   
LIST SYNONYMS
 
NONE
 
MAX ROWS
 
-1
 
NET PROTOCOL
   
OPEN MODE
 
READ/WRITE
 
ROWSET SIZE
 
20
 
SCHEMA CACHE DIR
   
SCHEMA CACHE SIZE
 
8
 
SCHEMA CACHE TIME
 
-1
 
SERVER NAME
 
ORACLE
 
SQLPASSTHRU MODE
   
SQLQRYMODE
   
USER NAME
 
(See comment #3)

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 Setup

ODBC Driver Setup

Driver Name: ODBC_ORA7332
Parameters: 
VERSION 
 
3.0
 
TYPE
 
SERVER
 
DLL
 
IDODBC01.DLL
 
DLL32
 
IDODBC32.DLL
 
ODBC DRIVER
 
Oracle73
 
DRIVER FLAGS
   
TRACE MODE
 
0
 
DATABASE NAME
   
USER NAME
   
ODBC DSN
 
ORA7332_ODBC
 
OPEN MODE
 
READ/WRITE
 
SCHEMA CACHE SIZE
 
8
 
SQLQRYMODE
   
LANGDRIVER
   
SQLPASSTHRU MODE
 
SHARED AUTOCOMMIT
 
SCHEMA CACHE TIME
 
-1
 
MAX ROWS
 
-1
 
BATCH COUNT
 
200
 
ENABLE SCHEMA CACHE
 
FALSE
 
SCHEMA CACHE DIR
   
ENABLE BCD
 
FALSE
 
ROWSET SIZE
 
20

ODBC Alias Setup

Alias Name: ORA7332_ODBC
Parameters: 
TYPE 
 
ODBC_ORA7332
 
PATH
   
DATABASE NAME
 
orant
 
USER NAME
   
ODBC DSN
 
ORA7332_ODBC
 
OPEN MODE
 
READ/WRITE
 
SCHEMA CACHE SIZE
 
8
 
SQLQRYMODE
   
LANGDRIVER
   
SQLPASSTHRU MODE
 
SHARED AUTOCOMMIT
 
SCHEMA CACHE TIME
 
-1
 
MAX ROWS
 
-1
 
BATCH COUNT
 
200
 
ENABLE SCHEMA CACHE
 
FALSE
 
SCHEMA CACHE DIR
   
ENABLE BCD
 
FALSE
 
ROWSET SIZE
 
20

Windows Registry Entries (95 or NT)
HKEY_LOCAL_MACHINE

Borland Entries: 

Key Name: SOFTWARE\Borland\Database Engine
Class Name: <NO CLASS>
Value 0
 
Name: CONFIGFILE01
 
Type: REG_SZ
 
Data: G:\PUBLIC\IDAPI32\IDAPI32.CFG
 
Value 1
 
Name: DLLPATH
 
Type: REG_SZ
 
Data: G:\PUBLIC\IDAPI32
 
Value 2
 
Name: RESOURCE
 
Type: REG_SZ
 
Data: 0009
 
Value 3
 
Name: SaveConfig
 
Type: REG_SZ
 
Data: WIN32
 
Value 4
 
Name: UseCount
 
Type: REG_SZ
 
Data: 4
Key Name: SOFTWARE\Borland\Database Engine\Settings
Class Name: <NO CLASS>

Key Name: SOFTWARE\Borland\Database Engine\Settings\DRIVERS
Class Name: <NO CLASS>

Key Name: SOFTWARE\Borland\Database Engine\Settings\DRIVERS\ODBC_ORA7332
Class Name: <NO CLASS>

Key Name: SOFTWARE\Borland\Database Engine\Settings\DRIVERS\ODBC_ORA7332\DB OPEN
Class Name: <NO CLASS> 
Value 0
 
Name: BATCH COUNT
 
Type: REG_SZ
 
Data: 200
 
Value 1
 
Name: DATABASE NAME
 
Type: REG_SZ
 
Data: ORACLE
 
Value 2
 
Name: ENABLE BCD
 
Type: REG_SZ
 
Data: FALSE
 
Value 3
 
Name: ENABLE SCHEMA CACHE
 
Type: REG_SZ
 
Data: FALSE
 
Value 4
 
Name: LANGDRIVER
 
Type: REG_SZ
 
Data: 
 
Value 5
 
Name: MAX ROWS
 
Type: REG_SZ
 
Data: -1 
 
Value 6
 
Name: ODBC DSN
 
Type: REG_SZ
 
Data: ORA7332_ODBC
 
Value 7
 
Name: OPEN MODE
 
Type: REG_SZ
 
Data: READ/WRITE
 
Value 8
 
Name: ROWSET SIZE
 
Type: REG_SZ
 
Data: 20
 
Value 9
 
Name: SCHEMA CACHE DIR
 
Type: REG_SZ
 
Data: 
 
Value 10
 
Name: SCHEMA CACHE SIZE
 
Type: REG_SZ
 
Data: 8
 
Value 11
 
Name: SCHEMA CACHE TIME
 
Type: REG_SZ
 
Data: -1
 
Value 12
 
Name: SQLPASSTHRU MODE
 
Type: REG_SZ
 
Data: SHARED AUTOCOMMIT 
 
Value 13
 
Name: SQLQRYMODE
 
Type: REG_SZ
 
Data: 
 
Value 14
 
Name: USER NAME
 
Type: REG_SZ
 
Data: 
Key Name: SOFTWARE\Borland\Database Engine\Settings\DRIVERS\ODBC_ORA7332\INIT
Class Name: <NO CLASS> 
Value 0
 
Name: DLL
 
Type: REG_SZ
 
Data: IDODBC01.DLL
 
Value 1
 
Name: DLL32
 
Type: REG_SZ
 
Data: IDODBC32.DLL
 
Value 2
 
Name: DRIVER FLAGS
 
Type: REG_SZ
 
Data: 
 
Value 3
 
Name: ODBC DRIVER
 
Type: REG_SZ
 
Data: Oracle73
 
Value 4
 
Name: TRACE MODE
 
Type: REG_SZ
 
Data: 0
 
Value 5
 
Name: TYPE
 
Type: REG_SZ
 
Data: SERVER
 
Value 6
 
Name: VERSION
 
Type: REG_SZ
 
Data: 3.0
Key Name: SOFTWARE\Borland\Database Engine\Settings\DRIVERS\ORACLE
Class Name: <NO CLASS>

Key Name: SOFTWARE\Borland\Database Engine\Settings\DRIVERS\ORACLE\DB OPEN
Class Name: <NO CLASS> 
Value 0
 
Name: BATCH COUNT
 
Type: REG_SZ
 
Data: 200
 
Value 1
 
Name: BLOB SIZE
 
Type: REG_SZ
 
Data: 32
 
Value 2
 
Name: BLOBS TO CACHE
 
Type: REG_SZ
 
Data: 64
 
Value 3
 
Name: ENABLE BCD
 
Type: REG_SZ
 
Data: FALSE
 
Value 4
 
Name: ENABLE INTEGERS
 
Type: REG_SZ
 
Data: FALSE
 
Value 5
 
Name: ENABLE SCHEMA CACHE
 
Type: REG_SZ
 
Data: FALSE
 
Value 6
 
Name: LANGDRIVER
 
Type: REG_SZ
 
Data: 
 
Value 7
 
Name: LIST SYNONYMS
 
Type: REG_SZ
 
Data: NONE 
 
Value 8
 
Name: MAX ROWS
 
Type: REG_SZ
 
Data: -1
 
Value 9
 
Name: NET PROTOCOL
 
Type: REG_SZ
 
Data: 
 
Value 10
 
Name: OPEN MODE
 
Type: REG_SZ
 
Data: READ/WRITE
 
Value 11
 
Name: ROWSET SIZE
 
Type: REG_SZ
 
Data: 20
 
Value 12
 
Name: SCHEMA CACHE DIR
 
Type: REG_SZ
 
Data: 
 
Value 13
 
Name: SCHEMA CACHE SIZE
 
Type: REG_SZ
 
Data: 8
 
Value 14
 
Name: SCHEMA CACHE TIME
 
Type: REG_SZ
 
Data: -1
 
Value 15
 
Name: SERVER NAME
 
Type: REG_SZ
 
Data: 
 
Value 16
 
Name: SQLPASSTHRU MODE
 
Type: REG_SZ
 
Data: SHARED AUTOCOMMIT
 
Value 17
 
Name: SQLQRYMODE
 
Type: REG_SZ
 
Data: 
 
Value 18
 
Name: USER NAME
 
Type: REG_SZ
 
Data: 
Key Name: SOFTWARE\Borland\Database Engine\Settings\DRIVERS\ORACLE\INIT
Class Name: <NO CLASS> 
Value 0
 
Name: DLL
 
Type: REG_SZ
 
Data: SQLD_ORA.DLL
 
Value 1
 
Name: DLL32
 
Type: REG_SZ
 
Data: (*)
 
Value 2
 
Name: DRIVER FLAGS
 
Type: REG_SZ
 
Data: 
 
Value 3
 
Name: TRACE MODE
 
Type: REG_SZ
 
Data: 0
 
Value 4
 
Name: TYPE
 
Type: REG_SZ
 
Data: SERVER
 
Value 5
 
Name: VENDOR INIT
 
Type: REG_SZ
 
Data: (**)
 
Value 6
 
Name: VERSION
 
Type: REG_SZ
 
Data: 1.0

(*)   Set to SQLORA32.DLL for Oracle 7 and to SQLORA8.DLL for Oracle 8.
(**) Set to ORANT71.DLL, ORA72.DLL, ORA73.DLL, or ORA805.DLL depending on Oracle Client version.
 

Oracle entries:

Oracle 7 

Key Name: SOFTWARE\ORACLE
Class Name: Application Global Data
Value 0
 
Name: NET22
 
Type: REG_SZ
 
Data: D:\ORANT7x\NETWORK
 
Value 1
 
Name: NLS_LANG
 
Type: REG_EXPAND_SZ
 
Data: AMERICAN_AMERICA.WE8ISO8859P1
 
Value 2
 
Name: ORACLE_HOME
 
Type: REG_EXPAND_SZ
 
Data: D:\ORANT7x
 
Value 3
 
Name: RDBMS72
 
Type: REG_EXPAND_SZ
 
Data: G:\ORA7_SRV\RDBMS7x
 
Value 4
 
Name: TCP_HOSTS_FILE
 
Type: REG_SZ
 
Data: D:\WINNT\SYSTEM32\DRIVERS\ETC\HOSTS
 
Value 5
 
Name: TCP_PORT
 
Type: REG_DWORD
 
Data: 0x5f5
 
Value 6
 
Name: TCP_SERVICES_FILE
 
Type: REG_SZ
 
Data: D:\WINNT\SYSTEM32\DRIVERS\ETC\SERVICES
 
Value 7
 
Name: TCP_VENDOR
 
Type: REG_SZ
 
Data: WINSOCK

Oracle 8 

Key Name: SOFTWARE\ORACLE
Class Name: Application Global Data
Value 0
 
Name: NET80
 
Type: REG_SZ
 
Data: D:\ORANT8\NET80
 
Value 1
 
Name: NLS_LANG
 
Type: REG_EXPAND_SZ
 
Data: AMERICAN_AMERICA.WE8ISO8859P1
 
Value 2
 
Name: ORACLE_HOME
 
Type: REG_EXPAND_SZ
 
Data: D:\ORANT8
 
Value 3
 
Name: RDBMS80
 
Type: REG_EXPAND_SZ
 
Data: D:\ORANT8\RDBMS80
 
Value 4
 
Name: TCP_HOSTS_FILE
 
Type: REG_SZ
 
Data: D:\WINNT\SYSTEM32\DRIVERS\ETC\HOSTS
 
Value 5
 
Name: TCP_PORT
 
Type: REG_DWORD
 
Data: 0x5f5
 
Value 6
 
Name: TCP_SERVICES_FILE
 
Type: REG_SZ
 
Data: D:\WINNT\SYSTEM32\DRIVERS\ETC\SERVICES
 
Value 7
 
Name: TCP_VENDOR
 
Type: REG_SZ
 
Data: WINSOCK

ODBC entries: 

Key Name: SOFTWARE\ODBC
Class Name: <NO CLASS>
Key Name: SOFTWARE\ODBC\ODBCINST.INI
Class Name: <NO CLASS>

Key Name: SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
Class Name: <NO CLASS> 
Value 0
 
Name: Oracle73
 
Type: REG_SZ
 
Data: Installed
Key Name: SOFTWARE\ODBC\ODBCINST.INI\Oracle73
Class Name: <NO CLASS> 
Value 0
 
Name: Driver
 
Type: REG_SZ
 
Data: D:\ORANT73\ODBC\sqo32_drv.dll
 
Value 1
 
Name: Orahelp
 
Type: REG_SZ
 
Data: D:\ORANT73\MSHELP\drvora32.hlp
 
Value 2
 
Name: Setup
 
Type: REG_SZ
 
Data: D:\ORANT73\ODBC\sqo32s73.dll
HKEY_CURRENT_USER

ODBC entries: 

Key Name: Software\ODBC\ODBC.INI
Class Name: <NO CLASS>
Key Name: Software\ODBC\ODBC.INI\ODBC Data Sources
Class Name: <NO CLASS>
Value 0
 
Name: ORA7332_ODBC
 
Type: REG_SZ
 
Data: Oracle73
Key Name: Software\ODBC\ODBC.INI\ORA7332_ODBC
Class Name: <NO CLASS> 
Value 0
 
Name: Driver
 
Type: REG_SZ
 
Data: D:\ORANT73\ODBC\sqo32_73.dll
 
Value 1
 
Name: Server
 
Type: REG_SZ
 
Data: orant

Required 32-bit Oracle Files for connecting to your Oracle Workgroup Server

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 FOR ORACLE 7
 
ORACLE 8
 
Main modules:
 
ORANT71.DLL
 
ORA72.DLL
 
ORA73.DLL
 
 
 
ORA805.DLL
  
CORENT23.DLL
 
CORE34.DLL
 
CORE35.DLL
 
 
 
CORE40.DLL
  
ORASPAWN.DLL
 
CORE340.DLL
 
CORE350.DLL
  
    
NLSRTL31.DLL
 
NLSRTL32.DLL
   
NLSRTL33.DLL
  
TNS modules:
       
SQLTNSNT.DLL
 
NI80.DLL
        
NLNT.DLL
 
NL80.DLL
        
NTNT.DLL
 
NT80.DLL
        
NSNT.DLL
 
NS80.DLL
        
NTUSNT.DLL
 
NTUS80.DLL
  
SPX modules:
       
NTSNT.DLL
 
NTS80.DLL
  
TCP/IP modules:
       
NTTNT.DLL
 
NTT80.DLL
  
NMP modules:
       
NTNNT.DLL
 
NTN80.DLL

Required 32-bit ODBC Files for connecting to your Oracle Workgroup Server

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 Windows95 System directory or your Windows NT System32 directory depending on which OS you are running: 

ODBCINT.DLL, ODBC32.DLL, ODBCCP32.DLL
And the following one in your %ORACLE_HOME%\ODBC directory: 
SQO32_73.DLL
Required 32-bit Oracle files for connecting to Personal Oracle 7.1 and Personal Oracle for Windows95

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

Copyright ã 1999, George Pujol - Pujol Computer Consulting Inc.
This document cannot be modified without prior consent from Pujol Computer Consulting Inc.