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

Technote (FAQ)


Question

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?

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:

http://www.ibm.com/developerworks/data/library/techarticle/dm-0912securesockets1/index.html

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

Rate this page:

(0 users)Average rating

Add comments

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:

2013-08-27

Translate my page

Machine Translation

Content navigation