Use ODBC to connect to the SS database (Merant 3.70, SQL89)

Server: Redhat Linux Enterprise 4.0 + Progress restart SP9
Client: Windows XP Professional SP2
First download the Merant ODBC 3.7 For Progress connector, which is the ODBC driver of Progress, after the installation is complete, you can see the MERANT 3.70 32-bit PROGRESS driver in [Control Panel]-[Administrative Tools]-[ODBC Data Source.
: Http://www.blue-eyeds.net/temp/odbc3.7.rar (SN: 110000402830 Key: 78161385)
Note: The Progress connector Win32 comes with a Merant ODBC 3.60 driver. The connection method is different from 3.70. For details, see connect to the Progress database using ODBC (Merant 3.60, SQL92 ), I have not passed the test yet. I hope you can give me some advice.
Linux Server:
1. log on to the Linux Server (preferably the root user) and add a line in the/etc/services configuration file.
Merant 50000/tcp # merant ODBC
Note: merant is the name of the service that is enabled. I can use merant for identification. The port number 50000 is also set by myself as long as the system does not use this port, tcp is a port type, # followed by a comment.
2. Start the ODBC Service in Progress:
/App/progress/logs/bin/_ prooibk-SV-S merant
Note: There is no explanation. Execute the _ prooibk command in the Progress installation directory and open the merant port (50000 here) as the ODBC Service port, if the execution is successful, you will see two lines of information. Otherwise, check whether the port is in use.
　　
Windows client:
1. Add a line to the C: \ windows \ system32 \ drivers \ etc \ services file:
Merant 50000/tcp # merant ODBC
Note: This is the same as the configuration on the Linux Server above. It must be consistent with the server. Port 50000 is used above, and port 50000 is also used here.
2. Configure the data source and add a data source. The options are as follows:
[General]
Data Source Name: Name the Data Source for reference in the program
Description: Description of the data source.
Database Name: Name of the Database, such as mfgprod
User ID: do not fill in (this User name is the User name of the Progress database itself, not a Windows or Linux User, or MFG/PRO User, if the database is set to reject anonymous access, you must fill in)
　　
[Oid/Oib Options]
Protocol: TCP (connection type, which is the connection type you set in the services file)
Service Name: Port Name, the port Name of merantODBC in the services file, such as merant (in fact, you can directly use the port number, so that you do not need to define the port 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 (the connection Mode is divided into Direct and Via Server. It is best to use Via Server. If Direct is used, enter the physical path of the Database in the Database path, you do not need to fill in the following items)
Protocol: TCP (this should be the port type of your database. I haven't figured it out yet. Generally, just enter TCP)
Service Name: indicates the port Name of the database to be started (Note: This is the port Name of your database, that is, the port you set with the mfgutil tool on the server side. Do not ask me how to use mfgutil, I really don't know. You can check the corresponding database in MFG/PRO. pf file, which is written in)
Host Name: server Name or IP address (recommended IP address)
　　
Finally, click Test Connect to Test the connection. If the connection is successful, Connect establish is displayed.
　　
In fact, it is not complicated to use ODBC to connect to SS. In general, it is to start the ODBC Service on the server side and then connect to the client using ODBC software. Other steps are just for convenience, such as defining ports, or add a search path (this step is omitted in this tutorial). The key is to start ODBC on the server.