Kbase P98597: ODBC connection fails using SSL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/17/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0B
DataDirect 4.20 32-Bit OpenEdge SQL92 10.0B
Windows
SYMPTOM(s):
ODBC connection fails using SSL
[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Client/Server SSL Encryption handshake failure
ODBC Test connect also fails with the same error
JDBC connection works fine.
CAUSE:
The DLC environment variable is not set.
This error appears because the CA's root certificate can not be accessed by the SQL client in order to validate the identity of the SSL server. This CA's root certificate is located in %DLC%\Certs.
Since the DLC variable is not set, the identity of the SSL server can not be validated, and therefore the SSL connection process is aborted.
FIX:
There are 2 options. Be aware that the first option could generate conflicts if there are different versions of Progress installed on the machine.
- Set the DLC environment variable in the Windows System environment variables.
On Windows XP, follow the steps below:
1- Open the "Control Panel"
2- Click on "System"
3- Click on the tab "Advanced"
4- Click on the button "Environment Variables" and define the DLC variable
OR
- Start the ODBC client from a .BAT file where the DLC variable points to [OpenEdge Install].
Example of .BAT file:
SET DLC=C:\Progress\OpenEdge
C:\WinSQL\Winsql.exe