Kbase P10195: How to setup ODBC connection for Local OIB/OID on Windows 95
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/08/2003 |
|
Status: Verified
GOAL:
How to setup ODBC connection for Local OIB/OID on Windows 95
FACT(s) (Environment):
Windows 95
CAUSE:
Many customer are asking for information how to setup their ODBC
connection, this document will assist them with this.
FIX:
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.