Consultor Eletrônico

Status: Verified

GOAL:

How to establish an ODBC connection with SQL-89

GOAL:

Step by step how to connect a third party software to PROGRESS database using ODBC.

GOAL:

How to configure a connection from a non-Progress application to a Progress database.

GOAL:

How to configure / install Merant 3.60 SQL-89 ODBC driver.

FIX:


Prerequisite: You will need to have at least a Progress Client/Networking license installed on the client in order to connect successfully! NOTE - You can either connect to a database locally on your machine or on a UNIX box on the network. Both configurations are done almost the same way. The only difference is that when you do it locally, you set all of the environment variables and start the oibrkr32.exe and the database server on your machine. I suggest that you try both options. Set the following Environment variables on the client: Control Panel\System\Environment tab Make sure that you put the variables in the System Variables field in the System Properties, not in the User Variables field! PROMSGS=%DLC%\PROMSGS PROCFG=%DLC%\PROGRESS.CFG IDLC=%DLC%

IPROMSGS=%DLC%\PROMSGS The add the %DLC%\bin to the PATH environment variable





Set the following environment variables on the machine where the database
server is started:

PROOIBRK=%DLC%\BIN\OIBRKR32.EXE
PROOIDRV=%DLC%\BIN\OIDRVR32.EXE


Edit the services file:

Associate one service entry for the oibrkr32.exe and one for the database
server on the machine where you have started them. If the database server
and the ODBC client are on different machines, you have to edit the services
file also on the client and add an entry for the oibrkr32.exe which has to
be identical to the entry on the database machine.

Example of services file:

servicename1 8888/tcp # Service for the Database Server
servicename2 9999/tcp # Service for the oibrkr32.exe


The services file can be found in the following directory on Windows NT:
C:\WINNT\system32\drivers\etc\

Start th