Kbase P3363: SQL92 - How to resolve internal error 219901
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/12/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows NT 32 Intel/Windows 2000
Caldera Open UNIX/SCO UnixWare
Compaq Tru64 UNIX
HP-UX
IBM AIX
Linux Intel
SYMPTOM(s):
Error attempting to connect to database via ODBC/SQL92
Startup of SQLSRV2 process in database log file shows no Classpath being set.
SQLSRV2 1: CLASSPATH from DEFAULT is:
ODBC testconnect : [Merant SQL92 - ODBC Progress Driver [Progress] -219901]
SQL92 internal error 219901
CAUSE:
The log file shows that there is no CLASSPATH environment variable set for the SQLSRV2 process.
FIX:
1) Add CLASSPATH system environment variable pointing to %DLC%\java\progress.zip.
Example: set CLASSPATH=D:\Progress9\java\progress.zip
Note: In Progress 9.1D, the progress.zip file has been renamed to progress.jar
2) Restart AdminService.
3) Restart the database.