Kbase P172494: ODBC connection failing with a WRKDIR variable pointing to a networked drive
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/31/2010 |
|
Status: Unverified
SYMPTOM(s):
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error %s (%s) in SQL from subsystem %s function %s called from %s on %s for %s.
Error attempting to connect via ODBC or JDBC to an OpenEdge Database
Error occurs if the database is started from the command line
Error occurs if the database is started via the AdminServer
FACT(s) (Environment):
Able to connect remote 4GL clients.
Able to spawn a _sqlsrv2 process manually
Windows
OpenEdge 10.x
CAUSE:
The database log file shows that the _sqlsrv2 process has a WRKDIR being set to a networked drive. The user starting the database likely does not have sufficient priveledges to write to the drive.
FIX:
Some workarounds are:
1) Remove the WRKDIR setting in the Environment Variables and allow the WRKDIR defined during install to remain in place.
2) Change the WRKDIR variable to point to a local drive
3) Make sure the user starting the database has sufficient write priveledges to the networked drive.