Discovering a Progress server's sockets definition

1. Log in to your Progress DBMS server.
   
2. Locate the database log file. Typically, the log file should have the same name as the database .db file with a .lg extension; e.g., the sports92.db file will typically have a corresponding sports92.lg file.
   
3. Make a copy of the database log file.
   
4. Open the copy with a text editor.
   
5. Locate the section covering to the most recent database startup.
   
6. Find the socket parameters. For example:
   
   

   
   1:50:04 BROKER  0: Host Name (-H): oplusaix3. (4261)
   1:50:04 BROKER  0: Service Name (-S): pro91d. (4262)
   1:50:04 BROKER  0: Network Type (-N): tcp. (4263)
   

   
   
7. Record the value shown for Host Name. Some versions of Progress will only connect if your ODBC connection specifies exactly the same value -- i.e., oplusaix3.example.com and 192.168.123.234 will not work for the above instance, even if they all resolve to the same IP address; only oplusaix3 will work.
   
8. Record the value shown for Service Name. This is your database's socket service name or number.
   
9. Exit the .lg file. The copy you made may safely be discarded.
   
10. If you found a service name above, and not a port number, grep the local /etc/services file for the service name to identify the associated TCP port number. For example:
    
    

    
    % grep pro91d /etc/services
    pro91d   8893/tcp
    

    
    
11. Exit the file.