Kbase 20912: SQL-92 Connection Error: No Suitable Driver on Windows
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2011 |
|
Status: Verified
SYMPTOM(s):
Error connecting to a Progress database through the Progress SQL Explorer Tool.
SQL-92 Connection Error: No Suitable Driver.
OK button alert- box entitled "wjview.exe - Entry Point Not Found"
The procedure entry point
PRO_SQLDA_Set_DA_Attribute_dh_u32_t could not be
located in link library PROCLI92.dll
Second OK Alert Box:
Error: No suitable driver. (8933)
=== SQL Exception 1 ===
SQLState=08001
ErrorCode=0
No suitable driver
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
Progress 9.x
OpenEdge 10.x
CAUSE:
The wrong version of the dynamic link library PROCLI92.dll is being used. More specifically, the messages are generated if there is a version mismatch between the installed Progress and the PROCLI92.dll.
FIX:
Use the windows "Find File" utility to locate all copies of Dynamic link library PROCLI92.dll on the system.
If more than one copy is found, and if one of them is in the WINNT\system32 directory, this is the version that is being used in the connection attempt. The version of the PROCLI92.dll in this directory is older than the one needed.
This "wrong" version was installed there by an an earlier Progress version. Compare the dates and version of the PROCLI92.dll in this directory with the one that resides in the DLC\bin directory. If the one in the DLC\bin directory is newer, then rename the PROCLI92.dll copy in the WINNT\system32 directory. This will allow Progress to use the correct version that is in DLC\bin.