Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  SDK CLIENT UBUNTU

    Posted Wed May 07, 2025 12:28 PM

    Hi everyone
    I'm having trouble configuring the SDK client on Ubuntu. My client is running version 14.10.FC11WE and I have the client: Informix.4.50.FC11
    I've already configured /etc/odbcinst.ini as: [Informix]
    Description=IBM Informix ODBC Driver
    Driver=/opt/IBM/Informix.4.50.FC11/lib/cli/iclit09b.so and in /etc/odbc.ini [caja]
    Description=ODBC Connection to Informix
    Driver=Informix
    Database=db
    Servername=sn_caja_aux
    Host=ip
    Service=2325
    Protocol=onsoctcp
    UID=user
    PWD=password,sql host: sn_caja_aux onsoctcp ip 2325 but when I connect I get the error: ERROR [IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified



    ------------------------------
    Eduardo Rodriguez
    ------------------------------


  • 2.  RE: SDK CLIENT UBUNTU

    Posted Wed May 07, 2025 05:47 PM

    Two things stand out to me:

    1. Your /etc/odbcinst.ini needs this line:

    IBM Informix ODBC DRIVER=Installed

    2. You need to specify the driver in /etc/odbc.ini:

    Change "Driver=Informix" to 

    Driver=/full/path/to/iclit09b.so

    See my working example below.


    In the system-wide ODBC drivers config file /etc/odbcinst.ini:

    ;-----------------------------------------------------------------------
    ; Section 1:  List of ODBC drivers installed on the system
    [ODBC Drivers]
    IBM Informix ODBC DRIVER=Installed
    ;-----------------------------------------------------------------------
    ; Section 2:  List of properties for specific ODBC driver(s). 
    [IBM Informix ODBC DRIVER]
    Description=IBM Informix ODBC Driver
    Driver=/opt/informix/lib/cli/iclit09b.so
    Setup=/opt/informix/lib/cli/iclit09b.so
    APILevel=1
    ConnectFunctions=YYY
    DriverODBCVer=03.51
    FileUsage=0
    SQLLevel=1
    smProcessPerConnect=Y
    ;-----------------------------------------------------------------------
    ; Section 3:  ODBC global options such as Unicode or Tracing
    [ODBC]
    Trace = no
    TraceFile = /tmp/odbctrace.log


    I put my individual connection setups in ~/.odbc.ini but these should
    work for system-wide use in /etc/odbc.ini:

    [stores_demo]
    Description=IBM Informix 12.10 stores_demo database via ODBC
    Driver=/opt/informix/lib/cli/iclit09b.so
    Database=stores_demo
    ; Informix uses OS authentication, so does not need LogonID or pwd,
    ; if the client is on the same system as the database server.
    ; Might need this if connecting remotely (UNTESTED).
    ;LogonID=odbc
    ;pwd=odbc
    Servername=ids12de
    CursorBehavior=0
    CLIENT_LOCALE=en_us.8859-1
    DB_LOCALE=en_us.8859-1
    TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so


    Notes:
    * Make /opt/informix a symlinks to your installed version of Informix
      (e.g., /opt/ibm/informix/ids12.10.FC16W1DE) so you don't have to 
      update the ODBC configuration files if/when Informix is upgraded.
    * I'm only using a local connection, not over TCP/IP, but your Host,
      Service, Protocol, UID look OK.
    * Set Trace=yes in /etc/odbcinst.ini (Section 3) to help debug.
      The log file is whatever you set TraceFile to, /tmp/odbctrace.log
      in my example.

    scot




  • 3.  RE: SDK CLIENT UBUNTU

    Posted Wed May 07, 2025 05:53 PM

    I found Lester Knutsen's video helpful:

    Connecting Users and Tools to Informix Servers - skip to 36 minutes in 
    the video[1] or look at the slides[2] for how to set up a unixODBC 
    connection to Informix.

    [1] https://advancedatatools.com/webcasts/informix-tutorial-connecting-users-and-tools-to-informix-servers/
    [2] https://advancedatatools.com/wp-content/uploads/2020/06/Informix_Tutorials-Connecting_to_Informix.pdf