Status: Unverified
GOAL:
How to use MERANT ODBC 3.x Driver with Local DB on Windows95 / Windows 98.
FACT(s) (Environment):
Windows 95
Windows 98
Progress 8.x
FIX:
The elements:
- MS-Query connects to the MERANT ODBC Driver.
- MERANT ODBC Driver connects to the Progress Open Interface Broker (OIB).
- Progress OIB spawns a Progress Open Interface Driver (OID) for the specific database.
- Progress OID accesses the database and retrieves data for MS-Query.
Steps for the connection:
1) Set the environment for Windows 95/98 (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
2) Start server for database.
%DLC%\BIN\_MPROSRV <drive:\path\db-name>
(make sure you use the complete path to the
database.)
3) Start the OIB.
%DLC%\BIN\OIBRKR32 -SV -S <oib-service> -H
localhost -N TCP
(make sure you type the parameters in
capitals.)
4) Configure ODBC DataSource.
a) Start 32bit ODBC Administrator.
b) Select PROGRESS DataSource.
c) Click Add.
d) Select INTERSOLV 3.01 driver.
e) Click Finish.
f) Select the tab General:
- Data Source Name: <choose a name>
- Description: <choose a description>
- Database Name: <db-name>
- User ID:
g) Select tab OID/OIB Options:
- Protocol: TCP
- Service Name: <oib-service>
- Host Name: localhost
h) Select the Database Options tab:
- Database Acces Mode: Direct
- Database Path: <db-path> *
- Database Operating System: Windows.
- Click OK.
i) Click OK (to exit ODBC Administrator)
j) Make sure you add a backslash (\) at the end of the
db-path, and do not include the name of the database.
5) Connect to 32-bit MS-Query (version 2.00)
a) Select New Query.
The first time your DataSource is not in the in the list:
- Click Other.
- Select the DataSource you have created.
- Click OK.
b) Click OK to log on.
- Select your DataSource.
- Click Use.
The tables of your Progress database are available.
To stop the Open Interface Broker (OIB);
%DLC%\BIN\_MPRSHUT -SV -S <oib-service>
To stop the database server;
%DLC%\BIN\_MPRSHUT <db-name>