I am setting the default isolation level to blank since setting to read uncommitted seems to produce errors. Progress OpenEdge Wire Protocol, Progress OpenEdge 10.1x, 10.2x, 11.0, 11.1. Tentative partial recommendations include running update statistics on the database and setting the Fetch Array Size in the ODBC connection to a much larger value. For information about DataFlux drivers (rebranded DataDirect drivers). Performance of this connection with large models is problematic at the moment and is being researched.

Note that there is further detail on this process in the Help for EA under the topic 'Set up a Progress OpenEdge ODBC Driver'. Click OK to exit until no longer in the tool. If the test does not succeed, review your settings.ĩ. If the test succeeds, click on the OK button to complete the configuration.Ĩ. Same query works as expected when using a later version of the ODBC driver, DataDirect Connect v7.10.06.175. Same query works as expected and updates the record when using a Linked Server based upon the OpenEdge 11.5.1 or lower ODBC driver. Click on the Test Connect button to confirm that the details are correct.ħ. Linked Server uses the OpenEdge 11.6 ODBC driver. Note, you must use the service/port number and not the name.Ħ. The Database Name on the selected server.In the start.pdf file, click on a title below to open a PDF version of an OpenEdge manual in Adobe Reader. After you have downloaded and extracted the set, open the start.pdf to access each document in the set. The Host Name and Port Number of the DBMS server Click Here to download the entire Progress OpenEdge 11.6 documentation set in PDF format.Enter the following configuration details: Deployment DataServers and ODBC Odbc For Progress 11.6 catch.saravana catch.saravana Member 1 We have an ERP system (running on Windows) that has to access Progress DB (running on Linux) with ODBC connection. Select the DataDirect/OpenEdge SQL or other appropriate Progress driver from the list. The Create New Data Source dialog displays, enabling you to add a new DSN.ģ. The ODBC Data Sources Administrator window displays. Select the Windows Control Panel | Administrative Tools | Data Sources (ODBC) option. The following assumes that Enterprise Architect is being used on a Windows platform.ġ.

Progress openedge 11.6 driver