How to use Intersolv ODBC driver 3.01 with Novell database
HOW TO CONNECT INTERSOLV ODBC DRIVER 3.01 TO NOVELL PROGRESS DATABASE
NOTE: This configuration is not supported according to Intersolv
documentation, but it seems to work fine.
Environment for this scenario:
Server:
Netware NLM Server
Progress 7.3C WorkGroup Database Server
Client:
Windows 95 (with Service Packs applied)
Microsoft Query 2.00
Progress 8.2B (or later)
Minimum licence required is Client/Networking
Intersolv ODBC Driver 3.01
Theory of operation:
Intersolv only supports remote OIB's with its 32 bits driver
because Progress does not supply a local OID with the 8.2
product (in 8.1 it was called WOIDRVR.EXE). But 8.2 supplies
remotes OIB/OID called OIBRKR32.EXE/OIDRVR32.EXE which can be used
locally in a Windows 95 computer.
The elements involved are:
- MS-Query connects to Intersolv ODBC Driver.
- Intersolv ODBC Driver connects to Progress Open Interface
Broker (OIB).
- Progress OIB spawns a Progress Open Interface Driver (OID)
for the specific database.
- Progress OID acceses the database and retrieves data for
the MS-Query.
Steps for the connection:
1. Start server on Novell:
LOAD _MPROSRV.NLM DAT:<db-path> -S <db-service> -N TLI -AUTOEXIT
2. Set the environment in Windows 95 (in AUTOEXEC.BAT):
SET DLC=<dlc-path>
SET PROMSGS=%DLC%\PROMSGS
SET PROCFG=%DLC%\PROGRESS.CFG
SET IDLC=%DLC%
SET IPROMSGS=%IDLC%\PROMSGS
SET PROOIBRK=%DLC%\BIN\OIBRKR32.EXE
SET PROOIDRV=%DLC%\BIN\OIDRVR32.EXE -Mm 512
3. Start the OIB on Windows 95:
%DLC%\BIN\OIBRKR32.EXE -SV -S <oib-service> -H localhost -N TCP
4. Configure ODBC DataSource:
Start ODBC Administrator
Select PROGRESS DataSource
Click Add
Select INTERSOLV 3.01 driver
Click Finish
Select tab General:
Data Source Name: <choose a name>
Description: <choose a description>
Database Name: <db-name>
User ID:
Select tab OID/OIB Options:
Protocol: TCP
Service Name: <oib-service>
Host Name: localhost
Select tab Database Options:
Database Acces Mode: Via Server
Protocol: TCP or SPX
Service Name: <db-service>
Host Name: <novell-host-name>
Click OK
Click OK (to exit ODBC Administrator)
5. Connect with Microsoft Query 32 bits (version 2.00)
Select New Query
The first time your DataSource is not in the list:
Click Other
Select the DataSource you have created
Click OK
Click OK (to log on)
Select your DataSource
Click Use
The tables of your Progress database become available.
To stop the OIB:
%DLC%\BIN\_MPRSHUT -SV -S <oib-service>
jsa
30 Oct 97
31 Aug 98 updated
Progress Software Technical Support Note # 17369