Kbase P112399: ODBC or SQL connection Failed to create the Progress NLS handler - database is started with Progre
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows
OpenEdge SQL Category: JDBC Drivers
SYMPTOM(s):
Test connection fails with OpenEdge 10.0B
[DataDirect][ODBC OPENEDGE driver][OPENEDGE] Error in Network Daemon
[DataDirect][ODBC OPENEDGE driver]Invalid attribute in connection string: Description. [DataDirect][ODBC OPENEDGE driver][OPENEDGE] Failed to create the Progress NLS handler
[DataDirect][ODBC OPENEDGE driver][OPENEDGE] Failed to create the Progress NLS handler
[ODBC OPENEDGE driver]Invalid attribute in connection string
[JDBC Progress Driver]:Failed to create the Progress NLS handler
Failed to create the Progress NLS handler when connecting to database using ODBC.
Failed to create the Progress NLS handler when using SQL Explorer
Database is stated with Progress Explorer
Database is started by AdminService.
Everything worked until Host machine was booted.
Both SQL and ODBC connection works when the database is started from Proenv using proserve.
CAUSE:
DLC is not correct or the environment for Progress is corrupted.
FIX:
To solve this problem check the following:
1. If there are any DLC variable set in the System Properties - Advanced - Environment Variables, delete it.
2. If you are running two or more Progress version on the machine make sure the System Properties - Advanced - Environment Variables does not contain any DLC variables, it will make the other versions not being able to combine start of database with Progress Explore and SQL/ODBC connections.
3. If there is any traces of 'old' DLC settings, remaining after older removed Progress versions in the registry, delete it
4. If non of these options solves the problem a reinstallation of Progress is recommended
Note: After deleting the DLC environment variable you need to restart the machine in order for the AdminServer to pickup the change.