Kbase 18817: Client/Server Version Mismatch. (642) Progress V9 SQL89 ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
MERANT 3.50 32-BIT Progress SQL-89
MERANT 3.60 32-BIT Progress SQL-89
MERANT 3.70 32-BIT Progress SQL-89
SYMPTOM(s):
Error attempting to connect to a database via ODBC
Disconnected because of PROGRESS client/server version mismatch. (642)
Login refused; client has version <n> and server has version <n>. (1345)
Error establishing Open Interface Driver connection. (2575)
CAUSE:
An older copy of the prosql32.dll was found in the PATH environment before the current one.
The Merant ODBC driver 3.11 and 3.5 installs a copy of the version 8.x prosql32.dll in the \winnt\system32 directory. The winnt\system32 directory is before the %DLC%\bin directory in the Path statement causing the ODBC connection to find the wrong version of the prosql32.dll file first.
FIX:
For the Merant ODBC driver to connect to a Progress 9.x database, prosql32.dll must be the one provided with the Progress 9.x installation as well. In Progress 9.x, there is no prosql32.dll, but esql32.dll located in the DLC\bin directory. This file contains the equivalent functionality. To use this DLL and resolve these errors, copy\rename it to prosql32.dll and make sure it can be found via the PATH variable.
1) rename \winnt\system32\prosql32.dll
2) copy the v9 %DLC%\bin\esql32.dll to \winnt\system32\
3) rename the esql32.dll to prosql32.dll
4) verify that there are no other prosql32.dll's in your PATH