Kbase P120886: OpenEdge SQL: Unable to execute SQL-92 stored procedure or trigger on Windows
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/1/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0x
OpenEdge 10.1x
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
SQL-92 Stored Procedure and Trigger returns an error when executed.
SQL Exception:
SQLState=HY000
ErrorCode=-20211
[JDBC Progress Driver]:
Error -210022 when running SQL-92 stored procedure or trigger.
210022 DataDirect Technology Progress ODBC driver failed during dynamic load of
Java dynamic library resend 126.
[JDBC OpenEdge Driver]:Failed during dynamic load of Java dynamic library. Reason = [126]The specified module could not be found.
[jvm].
The SQL-92 Stored Procedure and Trigger compiled without errors.
CAUSE:
The shared library path has to include the correct paths for the JAVA JVM library or DLL.
FIX:
Before starting the database, set the PATH as follows :
set PATH=%DLC%\jre\bin\client;%PATH%
If you are starting the database using the AdminServer, then you will need to set the PATH in the System Environment Variables and restart your machine.