The reason for all this is that not many people access the Progress database via ODBC/JDBC and SQL92 - the vast majority uses the native ABL ( 4GL ) interface to talk to the Progress database. You either must do a complete or a custom installation and select the drivers manually.

Plus, if you did chose a 'typical' installation you will wind up without the ODBC drivers being installed. No SQL-92 ODBC Driver showing in Microsoft DSN Administrator. OpenEdge is an object database, so accessing its data.

If you chose 4GL ( which I believe is the default ) then you must provide the -ServerType SQL startup parameter to the proserve command because otherwise it will only start servers that can handle ABL ( 4GL ) clients. Progress ODBC drivers are not listed when trying to add a new ODBC Data Source. We support Progress OpenEdge in our products, but you will need to have its ODBC drivers installed. CDC Replication Both Pro2 v5 and Pro2 v6 can support either replication triggers or Change Data Capture (CDC) which delivers near real-time replication. For its Client OS products, Microsoft offers a choice of lifecycle support options: A. We recommend OpenEdge 12.x for Pro2 v6.2.x installs to take the advantage of PASOE improvements, or at least the latest 11.7 LTS update. This affects security ( ) and the SQL92 engine itself ( ).Īnohter important caveat: During installation you was asked whether you would like to server 4GL and/or SQL clients with the database ( don't remember the exact wording ). This section describes how Progress supports OpenEdge-based applications deployed on Windows Client Operating Systems on different support cycles. For the latest support information, visit the Progress DataDirect Supported Configurations page. There are several stepping stones and stumbling blocks for a Progress newbie - which are mostly caused by the fact that the Progress database does not provide SQL92 connectivity out-of-the-box in a way you would expect it. The DataDirect Connect for ODBC Progress OpenEdge Wire Protocol driver (the Progress OpenEdge Wire Protocol driver) supports Progress OpenEdge database systems and services.

Progress openedge odbc driver