Kbase P127984: Errors encountered when trying to connect 10.0B JDBC/ODBC client to a 10.1x SQL database server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/7/2008 |
|
Status: Unverified
SYMPTOM(s):
Attempting to connect to an OpenEdge 10.1x database using OpenEdge 10.0B JDBC/ODBC drivers
Connection attempts fail with errors
JDBC connectivity error:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20187
[JDBC OpenEdge Driver]:Mismatchedx protocol version.
No database connected. (8934)
ODBC connectivity error:
[DataDirect][ODBC OPENEDGE driver][OPENEDGE]-219901
FACT(s) (Environment):
OpenEdge 10.0B
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
This is expected behaviour. It is not supported to connect to an OpenEdge 10.1x database using OpenEdge 10.0B JDBC/ODBC drivers. This is true from OpenEdge 10.1A when type 4/wire protocol drivers were introduced into the product. For OpenEdge 10.1x and forward, the drivers are backward/forward compatible.
FIX:
Use the correct version of JDBC/ODBC drivers. Both the OpenEdge SQL database and the Client ODBC and JDBC Drivers must be at least at the same OpenEdge Enhancement version (i.e. 10.0 or 10.1).