Question & Answer
Question
How do you configure an ODBC connection on a Microsoft Windows machine to use Secure Sockets Layer (SSL) to connect to a remote Informix database server?
Answer
Steps:
1. Generate the client keystore (clikeydb.kdb), the stash file (clikeydb.sth) and import server's certificate on UNIX machine following the instructions specified in the following URL:
https://advancedatatools.com/article/setting-up-ssl-in-informix/
2. Copy the generated files (.kdb, .sth, .cert) from UNIX server to your Windows machine, under $INFORMIXDIR/ssl directory.
3. Update the conssl.cfg existing under $INFORMIXDIR/etc to point to the .kdb and the .sth file. Ensure the path for the .kdb and the .sth file specified in the conssl.cfg does not have any white space.
For example:
SSL_KEYSTORE_FILE C:\PROGRA~1\IBMINF~1\ssl\clikeydb.kdb
SSL_KEYSTORE_STH C:\PROGRA~1\IBMINF~1\ssl\clikeydb.sth
SSL_KEYSTORE_STH C:\PROGRA~1\IBMINF~1\ssl\clikeydb.sth
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVT2J","label":"Informix Tools"},"ARM Category":[],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"3.50.0;3.70.0;4.1.0"}]
Was this topic helpful?
Document Information
Modified date:
20 January 2022
UID
swg21638441