Vetacad Group

Offentlig·12 medlemmar

27 maj 2023

How to Use Merant 3.60 32-bit Progress SQL92 ODBC Driver to Connect to Progress Database

Merant 3.60 32-bit Progress SQL92 ODBC Driver: What You Need to Know

If you are looking for a way to connect a Progress database with a third-party ODBC client, you might be interested in Merant 3.60 32-bit Progress SQL92 ODBC driver. This is a driver that can enable SQL-92 access to a remote OpenEdge database using ODBC. In this article, we will explain what Merant 3.60 32-bit Progress SQL92 ODBC driver is, how to install and configure it, and what are its benefits and drawbacks.

merant 3.60 32-bit progress sql92 odbc driver 20

Download Zip

What is Merant 3.60 32-bit Progress SQL92 ODBC Driver?

Merant 3.60 32-bit Progress SQL92 ODBC driver is a software that can allow you to connect a Progress database with a third-party ODBC client such as WinSQL, Crystal Reports, Microsoft Access, etc. The driver can support SQL-92 syntax and features such as joins, subqueries, views, etc. The driver can also handle data types such as date, time, decimal, etc.

The driver works with the Open Interference Broker (OIBRKR32.EXE), which is a service that runs on the same machine as the database server. The OIBRKR32.EXE acts as a bridge between the ODBC client and the database server, translating the SQL-92 queries into native Progress queries and vice versa.

How to Install and Configure Merant 3.60 32-bit Progress SQL92 ODBC Driver?

To install and configure Merant 3.60 32-bit Progress SQL92 ODBC driver, you need to have the following prerequisites:

A Progress database server running on a remote machine.

A Progress Client/Networking license installed on the client machine.

A serial number for the Merant 3.60 32-bit Progress SQL92 ODBC driver.

An ODBC Data Source Administrator on the client machine.

Here are the steps to install and configure Merant 3.60 32-bit Progress SQL92 ODBC driver:

Start the database server on the remote machine using the following command: proserve -S

Start the Open Interference Broker on the same machine using the following command: oibrkr32.exe -SV -H -N TCP -S

Edit the services file on both machines and add an entry for the database server and the Open Interference Broker using the same port numbers as above.

Run the setup.exe for the Merant 3.60 32-bit Progress SQL92 ODBC driver on the client machine and enter the serial number when prompted.

Open the ODBC Data Source Administrator on the client machine and click System DSN.

Click Add and select Merant 3.6 32-bit Progress SQL-92 from the list of drivers.

Click Finish and enter a name for the Data Source name.

Enter the hostname of the database server machine.

Enter the port number of the Open Interference Broker.

Enter the database name.

Enter your user name and password if security is defined for the database, otherwise leave them blank.

Click Test Connect to verify the connection.

Click Apply to save the Data Source.

What are the Benefits and Drawbacks of Merant 3.60 32-bit Progress SQL92 ODBC Driver?

Merant 3.60 32-bit Progress SQL92 ODBC driver can offer some benefits such as:

It can enable SQL-92 access to a remote OpenEdge database using ODBC.

It can support various SQL-92 features such as joins, subqueries, views, etc.

It can handle various data types such as date, time, decimal, etc.

It can work with various third-party ODBC clients such as WinSQL, Crystal Reports, Microsoft Access, etc.

However, Merant 3.60 32-bit Progress SQL92 ODBC driver also has some drawbacks such as:

It requires a Progress Client/Networking license on the client machine.

It requires a serial number for installation.

It requires an Open Interference Broker service running on the same machine as the database server.

It may not support all SQL-92 features or data types that are available in newer versions of Progress or other databases.

Conclusion

Merant 3.60 32-bit Progress SQL92 ODBC driver is a software that can allow you to connect a Progress database with a third-party ODBC client using SQL-92 syntax and features. It requires some prerequisites such as a Progress Client/Networking license, a serial number, an Open Interference Broker service, and an ODBC Data Source Administrator. It has some benefits such as supporting various SQL-92 features and data types, but also some drawbacks such as requiring additional services and licenses, and not supporting all SQL-92 features or data types. Therefore, it should be used with caution and consideration.