title: Connecting to Informix DB from Linux - client SDK is installed
body: <p>I am working on configuring the ODBC.ini file to connect to a remote DB from a Debian server.  My background is mostly PHP and MySQL, so setting up an ODBC is new to me and would appreciate any help.  My understanding is that the every DSN needs to be configured in the ODBC.ini file, and I already have this information.  </p>
  
  <pre><code>;---------------------------------------------------------------------------
  ; IBM INFORMIX ODBC Sample File
  ;
  ; File:     odbc.ini
  ;
  ;---------------------------------------------------------------------------
  [ODBC Data Sources]
  Infdrv1=IBM INFORMIX ODBC DRIVER
  Infdrv2=IBM INFORMIX ODBC DRIVER
  ;
  ; Define ODBC Database Driver's Below - Driver Configuration Section
  ;
  [Infdrv1]
  Driver=/extra/informix/lib/cli/iclit09b.so
  Description=IBM INFORMIX ODBC DRIVER
  Database=stores_demo
  LogonID=odbc
  pwd=odbc
  Servername=ids_server1
  [Infdrv2]
  Driver=/extra/informix/lib/cli/iclis09b.so
  Description=IBM INFORMIX ODBC DRIVER
  Database=stores_demo
  LogonID=odbc
  pwd=odbc
  Servername=ids_server2
  CursorBehavior=0
  CLIENT_LOCALE=en_us.8859-1
  DB_LOCALE=en_us.8859-1
  TRANSLATIONDLL=/extra/informix/lib/esql/igo4a304.so
  ;
  ; UNICODE connection Section
  ;
  [ODBC]
  ;uncomment the below line for UNICODE connection
  ;UNICODE=UCS-4
  ;
  ; Trace file Section
  ;
  Trace=0
  TraceFile=/tmp/odbctrace.out
  InstallDir=/extra/informix
  TRACEDLL=idmrs09a.so
  </code></pre>
  
  <p>However, I would like to know if there's a utility or method of testing connectivity after the configuration is done on the client side.  There seems to be quite a bit of information on how to do it on Windows, much less of it on Linux.  Any help is appreciated.</p>