IBM Support

Configuring ODBC to use Secure Sockets layer (SSL) connection to connect to Informix database.

Technote (FAQ)


How does one configure an ODBC connection on a Windows machine to use Secure Sockets Layer (SSL) to connect to a remote Informix database server?



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:

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, you can specify something like this:

    SSL_KEYSTORE_FILE C:\PROGRA~1\IBMINF~1\ssl\clikeydb.kdb
    SSL_KEYSTORE_STH C:\PROGRA~1\IBMINF~1\ssl\clikeydb.sth

Document information

More support for: Informix Tools
Informix Client Software Development Kit (CSDK)

Software version: 3.5, 3.7, 4.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1638441

Modified date: 27 August 2013

Translate this page: