Kbase P127942: Unable to make JDBC connection to Progress Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/11/2009 |
|
Status: Verified
SYMPTOM(s):
Unable to make JDBC connection to Progress Database
Using SQLExplorer command line utility
Java exception error recorded in SQLExplorer.exceptions file
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error %s (%s) in SQL from subsystem %s function %s called from %s on %s for %s. Save log for Progress technical support.
Message (excp): [DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -20096 (temp db) in SQL from subsystem DSM SERVICES function dsmUserConnect called from sts_env_t on for . Save log for Progress technical support.
Unable to make SQLEXP connection to database even though SQL Server spawns
Database log file shows _sqlsrv2 properly spawns
FACT(s) (Environment):
OpenEdge 10.1x
CAUSE:
Permissions on the $WRKDIR improperly set. To check, run the following commands in sequence:
$DLC/bin/proenv
$DLC/bin/slib_env
$DLC/bin/java_env
Proserve the database
Then run the SQLEXP command. You should get a message reading unable to write to the $WRDIR.
FIX:
Add the necessary write permissions to the $WRKDIR. In the case above, group write permissions were missing from the $WRKDIR.