Connect to the SS database through ODBC

How to connect to the SS database through ODBC

16:52:30 | category:

Progress | font size subscription

Odbc ss odbc is not common and requires special ODBC tools and software to connect. The most commonly used tool is merant ODBC. Here we will introduce how to connect to progress database with merant3.7, because there may be different operating systems, of course the connection methods are somewhat different. to use merant3.7, you must install the SS database on the client.

Server UNIX (data inventory on UNIX), client window2000
Server Configuration:
1. Add a line of port to start ODBC in the/etc/services configuration file, for example:
Merant 6000/tcp # port of merantodbc

2. Add the variable and path to the. profile file of the user who needs to use ODBC.
For example:
DLC =/DLC/91E/* path of installation SS */
Prooibrk =/DLC/91E/bin/_ prooibk/* path of the program to be called */
Prooidrv =/DLC/91E/bin/_ prooidv/* path of the program to be called */
Path =/DLC/91E/bin: $ path
Export path
Export DLC
Export prooibrk
Export prooidrv

3. Execute the command to start ODBC
For example:
/DLC/91E/bin/_ prooibk-SV-s merant/* varies depending on the directory where progress is installed. merant is the port name added to services, the two sides can be named but must be the same */

Client Configuration:
1. Add a line in the services file of C: winntsystem32driversetc like the server configuration.
For example:
Merant 6000/tcp # port of merantodbc

2. Add environment variables on the system console. We recommend that you add environment variables for the system. These variables may vary depending on the directory where the client progress is installed.
Dlc c: DLC the directory where you installed the progress client pieces
Idlc C: DLC required only for 8.1 or higher clients
Promsgs C: dlcpromsgs the Directory and name of the message file
Ipromsgs C: dlcpromsgs required only for 8.1 or higher clients
Path C: dlcbin; C: DLC; C: winntsystem32; % PATH % example for Windows NT
Temp C: temp

3. Configure the ODBC data source as follows:
General:
Data Source Name: Name yourself
Description: casual
Database Name: Database Name
User ID: No

Oid/OIB options:
Protocol: TCP
Service name: Port name of merantodbc in the services file
Host Name: server name or IP address (IP address is recommended; otherwise, it must be resolved in the hosts file)

Database options:
Database Access Mode: via server
Protocol: TCP
Service name: the port name of the database to be started (the port name of the Database Service to be started on the server is also in the services file of the server)
Host Name: Name or IP address of the machine that starts the Database Service (recommended IP address)

After that, you can connect to the ECS instance.