Yes, an OpenEdge 10.2x (32- or 64-bit) ODBC driver will connect to an OpenEdge 10.1x (32- or 64-bit) database.
The database SQL server (_SQLSRV2) does not know if a client is 32- or 64-bit so combining a 64-bit ODBC driver with a 32-bit database (or vice versa) should not cause issues.
OpenEdge SQL supports JDBC/ODBC clients that are one Major version higher than the database.
However, in OpenEdge 10 an exception to this rule exists:
Starting in OpenEdge 10.1A, Type 4/wire protocol drivers were introduced.
Due to this change:
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.
So due to major changes in the Type 4/wire Connection Protocol, an OpenEdge 10.1x SQL-92 client cannot connect to a Progress 9.x database, and vice versa. When connecting to a Progress 9.x database via ODBC, use one of the following drivers:
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.1 32-Bit Progress SQL92
Any OpenEdge 11.x, 10.2x or 10.1x ODBC driver is backward compatible with lower OpenEdge versions down to OpenEdge version 10.1A included.
|
