Kbase 19213: How to setup ODBC connection for Local OIB/OID on Windows 95
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/1999 |
|
How to setup ODBC connection for Local OIB/OID on Windows 95.
INTRODUCTION:
=============
Many customer are asking for information how to setup their ODBC connection, this document will assist them with this.
ENVIRONMENT:
Windows 95
Intersolv/Merant ODBC Driver for Progress V.3.01 (or later).
In all the following setup information the Progress package was installed into the C:\DLC82A directory, if you installed into a different directory, please change the examples. The server machine has a TCP/IP host name of serv. The database on the Server is "sports".
PROCEDURAL APPROACH:
===========================
1. Make sure that the Progress version on the Server is Version 7.3C (or later)
2. Create an entry in the SERVICES file on the server machine for the database server. For example:
progdb 3099/tcp
3. This must be an unused port in the SERVICES file.
4. Start a progress database server on the server machine and make sure it is started with the networking information. For example:
proserve sports -N TCP -H serv -S progdb
5. Install Progress Version 8.2A (or later) on the client PC.
6. Install Intersolv/Merant DataDirect ODBC Driver for Progress Version 3.01 (or later).
7. Edit the AUTOEXEC.BAT file and add the following lines:
set IDLC=C:\DLC82A
set IPROMSGS=C:\DLC82A\PROMSGS
set PROOIBRK=C:\DLC82A\BIN\OIBRKR32.EXE
set PROOIDRV=C:\DLC82A\BIN\OIDRVR32.EXE
set DLC=C:\DLC82A
8. Add two services to the SERVICES file. One for the database connection and one for the Progress Open Interface Broker (OIB). The database service entry MUST be the exact same entry as in step 2 above. The other for the OIB can be any other unused entry.
For example:
progoib 3194/tcp
A handy hint - there must be at least one blank line at the end of the SERVICES file in Windows '95 or Windows NT.
9. Create a menu shortcut to start the OI Broker with this as the command line:
C:\DLC82A\bin\oibrkr32.exe -SV -N TCP -S progoib
The "Start In" directory should not be C:\DLC82A, make a new directory called C:\LOG and make it the "Start In" directory. There will be a log file created with valuable info in it.
10. Create another shortcut to shut the OI Broker down with this as the command line:
C:\DLC82A\bin\_mprshut.exe -SV -N TCP -S progoib
The "Start In" directory should be the same as in step 9.
11. Run the ODBC administrator from the Control Panel.
12. Click Add
13. Choose INTERSOLV (or Merant) Progress Driver
14. Use these settings for tabs:
General
Data Source Name ProgTest [Whatever you want - No spaces]
Description This is a test [Again, whatever you want]
Database Name sports [Database started in step 4]
User Id [Leave blank usually]
OID/OIB Options
Protocol TCP
Service Name progoib
Host Name localhost
Database options
Database Access Mode Via Server
Protocol TCP
Service progdb
Host serv
15. Now use an ODBC program and connect to the ProgTest datasource.
rwider (27/10/99)
Progress Software Technical Support Note # 19213