App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#Applicationintegration
#App Connect
#AppConnect
 View Only

  • 1.  Set up ODBC datasource on ACE

    Posted Tue March 08, 2022 12:16 PM
    Hy everyone,
    I have an on premises installation of ACE on a linux Power and an integration flow that needs to connect to a remote db2 server on AIX via ODBC.

    I have tried to configure the ODBC resources in this way:
    - copied the odbc.ini file on the path /product/ODBC/.
    - copied the file odbcinst.ini on the path /product/ODBC/
    - copied the file db2inst.ini on the path /product/ODBC/.

    Set the environment variables:
    - ODBCSYSINI=/product/ODBC
    export ODBCSYSINI
    - ODBCINI=/product/ODBC/odbc.ini
    export ODBCINI
    - DB2CLIINIPATH=/product/ODBC/db2cli.ini
    export DB2CLIINIPATH

    the odbc.ini file has this config
    ;#######################################
    ;#### List of data sources stanza ######
    ;#######################################
    [ODBC Data Sources].
    DB2DSDB=IBM Data Server driver included in ACE

    ;###########################################
    ;##### Individual data source stanzas ######
    ;###########################################
    [EAI4U_ODBC]
    DRIVER=/product/ace-product/server/ODBC/dsdriver/odbc_cli/clidriver/lib/libdb2o.so
    FileUsage=1
    DontDLClose=1

    ;##########################################
    ;###### Mandatory information stanza ######
    ;##########################################
    [ODBC]
    InstallDir=/product/ace-product/server/ODBC/drivers
    UseCursorLib=0
    IANAAppCodePage=4
    UNICODE=UTF-8

    the odbcinst.ini file has this configuration
    ;##########################################
    ;###### Mandatory information stanza ######
    ;##########################################
    [ODBC]
    Trace=no
    TraceFile=/product/logs/ace/odbc/odbctrace.out
    Threading=2

    and the db2cli.ini file has this configuration
    [EAI4U_ODBC]
    Hostname=*****
    Port=****
    Database=TEST

    However, when I execute the flow, I have these error:

    2022-03-07 16:13:46.782560Z: [Thread 1711307] (Msg 7/8) BIP2393E: Database error: ODBC return code '-1' from data source 'EAI4U_ODBC' using ODBC driver manager '/product/ace/ace-12.0.3.0/ie02/lib/libodbcinterface.so'.

    2022-03-07 16:13:46.782748Z: [Thread 1711307] (Msg 8/8) BIP2322E: Database error: SQL State ' '; Native Error Code '-1531'; Error Text '[unixODBC][IBM][CLI Driver] SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2cli.ini configuration file. Data source name specified in the connection string: "EAI4U_ODBC". '.


    Why?
    Thanks a lot.

    Paolo

    ------------------------------
    Paolo Alberti
    ------------------------------


  • 2.  RE: Set up ODBC datasource on ACE

    Posted Wed March 09, 2022 06:47 AM
    Hi Paolo,
    the DB2CLIINIPATH should point to the directory, not to the file itself.
    Therefore the definition should be DB2CLIINIPATH=/product/ODBC/

    Regards
    Sabina

    ------------------------------
    Sabina Rosa Luzzatti
    ------------------------------

    Original Message


  • 3.  RE: Set up ODBC datasource on ACE

    Posted Thu March 10, 2022 09:19 AM
    Hi Sabina.
     it works.

    Thank you.
    Paolo

    ------------------------------
    Paolo Alberti
    ------------------------------

    Original Message


Related Content