The JDBC/ODBC driver and the database have to be from the same Progress/OpenEdge version.
So for example, only a Progress 9.1E JDBC/ODBC client is supported against a Progress 9.1E database. A Progress 9.1D JDBC/ODBC client would not be supported against a Progress 9.1E database or vice versa.
The reason is that unlike with 4GL clients, sometimes the SQL-92 communication layer is changed between minor versions as well. Some of these mixed version configurations might work, but Progress does not explicitly do any testing on this and thus cannot guarantee that it will work.
Starting in OpenEdge 10.1A, Type 4/wire protocol drivers were introduced. Due to this change, OpenEdge SQL supports JDBC/ODBC clients that are one Major version higher than the database, as follows:
OpenEdge 10.1x and 10.2x Drivers are not backwards compatible with OpenEdge 10.0x or 9.1x.
OpenEdge 10.1x and later Type 4/wire protocol drivers, are both backward/forward compatible.
