(Optional) To configure a system DSN, click the System DSN tab.
Select Start then Control Panel then Administrative Tools then Data Sources (ODBC) to run the default ODBC client. The following process uses the Windows default ODBC client and more information is provided with the context-sensitive help and in the IBM Informix ODBC Driver Programmer's Manual. You can create a user DSN or a system DSN as both are supported.
INFORMIX ODBC DRIVER 64 BIT HOW TO
This section describes how to configure ODBC on a Windows system including configuring your DSN. IBM INFORMIX ODBC Sample File File: odbc.ini -Infdrv1=IBM INFORMIX ODBC DRIVERInfdrv2=IBM INFORMIX ODBC DRIVER Define ODBC Database Driver's Below - Driver Configuration Section Driver=/home/informix/ifx1170/lib/cli/iclit09b.soDescription=IBM INFORMIX ODBC DRIVERDatabase=stores_demoLogonID=odbcpwd=odbcServername=ids_server1Driver=/home/informix/ifx1170/lib/cli/iclis09b.soDescription=IBM INFORMIX ODBC DRIVERDatabase=stores_demoLogonID=odbcpwd=odbcServername=ids_server2CursorBehavior=0CLIENT_LOCALE=en_us.8859-1DB_LOCALE=en_us.8859-1TRANSLATIONDLL=/home/informix/ifx1170/lib/esql/igo4a304.so UNICODE connection Section adding here new ODBC DSNDriver=/home/informix/ifx1170/lib/cli/iclis09b.soDatabase=superstores_demoServername=ol_informix1170CursorBehavior=0CLIENT_LOCALE=en_us.8859-1DB_LOCALE=en_us.8859-1TRANSLATIONDLL=/home/informix/ifx1170/lib/esql/igo4a304.so uncomment the below line for UNICODE connection UNICODE=UCS-4 Trace file Section Trace=0TraceFile=/tmp/odbctrace.outInstallDir=/home/informixTRACEDLL=idmrs09a.so Configure a DSN according to the following example. On UNIX, you need to configure an odbc.ini file.You can use the one shipped with the Informix installation.