Kbase P12636: ODBC Test Connect fails with error 126
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
MERANT 3.7 ODBC Driver
Windows
DataDirect 4.20 32-Bit OpenEdge SQL92 10.0A
DataDirect 4.1 32-Bit Progress SQL92 9.1D
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Test connect through ODBC Administration\Data Sources fails
System error 126 is ERROR_MOD_NOT_FOUND - The specified module cannot be found
Client Networking License is installed
ivpro16.dll is registered as the driver in the registry
loading ivpro16.dll into dependency walker shows that prosql32.dll is the module that is not found
Specified driver could not be loaded due to system "error 126" (MERANT 3.70 32-BIT PROGRESS)
126 error on errno.h of Windows corresponds to ERROR_MOD_NOT_FOUND = The specified module cannot be found
CAUSE:
The prosql32.dll could not be found within the PATH environment variable.
The prosql32.dll is necessary to establish an ODBC connection to a Progress Database. The prosql32.dll is shipped with all Progress Client licenses and the Merant/Data Direct ODBC drivers to enable connectivity via ODBC. The prosql32.dll file was missing from the Merant 3.7 ODBC driver.
FIX:
The prosql32.dll file can be obtained from a Progress Client installation.
Place a copy of the <Progress Install>\bin\prosql32.dll file in a valid PATH location, such as WINNT\SYSTEM32.
If a copy of the prosql32.dll is not found, copy the <Progress Install>\bin\esql32.dll file into the WINNT\SYSTEM32 directory and rename the WINNT\SYSTEM32\esql32.dll to WINNT\SYSTEM32\prosql32.dll.