Kbase P150699: Cannot connect to a database using ODBC or JDBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/10/2009 |
|
Status: Unverified
SYMPTOM(s):
Cannot connect to a database using ODBC or JDBC
Clients receive a message that the database is not started.
Error: <command name | SQL Exception message>. (8933)
SQL server process terminated. (8841)
Command: which java is finding Java 1.1.8 instead of 1.3.1 java
FACT(s) (Environment):
Database was started with the proserve command.
Can connect to the database using 4GL clients in a client serer mode.
Multiple versions of Java installed on the machine.
IBM AIX
Progress 9.1E
CAUSE:
Environment is pointing to the wrong version of Java.
FIX:
Set the JREHOME environment variable to point to the correct version of Java. Then set PATH environment variable to make use of the JREHOME variable.
Example:
JREHOME=<path to java home directory>;export JREHOME
PATH=$JREHOME:$JREHOME/bin:$PATH;export PATH