Kbase P99609: Error when attempting JDBC connection to database. Error reads: java.sql.SQLException: [JDBC Progre
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/10/2009 |
|
Status: Verified
SYMPTOM(s):
SQL92 client can not connect to database and gets error Database not started.
Error displayed when attempting JDBC connection to database. Error reads:
java.sql.SQLException: [JDBC Progress Driver]: Database not started.
Permissions on Progress executables in $DLC/bin are correct.
Reviewed ls -al listing of database files.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Permissions on database files are not correct. The permissions on the database files did not allow for the _sqlsrv2 process to connect based on the owner and group of the _sqlsrv2 process and the owner and group of the database files.
FIX:
Modify permissions on the database files to allow for Reads and Writes by owner and group.
The _sqlsrv2 process should be owned by the same owner as the database files or be part of the same group as the group setting on the database files.