App Connect

 View Only
  • 1.  Add more than one ODBC connection to same Integration node

    Posted Mon February 21, 2022 11:47 AM
    Hi,

      I need to access different database to fetch the data in my service. So i have created one ODBC connection for one database and set up authentication through  mqsisetdbparam command and connected DB succesfully and tested through mqsicvp command and its working fine.

    Next, i created another ODBC connection for another DB and setup authentication through mqsidbparam and connected successfully. but when i try to test the connection through mqsicvp command  getting below details,


    BIP8272E: Datasource 'XCBDB' has not been associated with integration node 'appconnect-test'.
    This invocation of the mqsicvp command requires that the datasource name has been associated with the integration node, using the mqsisetdbparms command.
    Check that this datasource has been associated with the integration node.


    Is it possible to create the ODBC for 2 different database and associate to same Integration node?

    Regards,
    Jothi

    ------------------------------
    Jothiboss Murugan
    ------------------------------


  • 2.  RE: Add more than one ODBC connection to same Integration node

    Posted Tue February 22, 2022 03:52 AM
    Hi Jothiboss.
    This should absolutely be possible. 
    Did you give the two connections two different names? Can you send us your mqsisetdbparms commands? What OS and ACE version is this?

    Thanks,
    Lars


    ------------------------------
    Lars Dehli
    ------------------------------



  • 3.  RE: Add more than one ODBC connection to same Integration node

    Posted Tue February 22, 2022 04:15 AM
    Hi Lars,

     the below 2 commands executed successfully, Both (SQLDSN, XCPDB) are pointing different database which is in different ip.
    mqsisetdbparms appconnect-test -n SQLDSN-u sa -p ******
    mqsisetdbparms appconnect-test -n XCPDB -u sa -p ******

    we are using windows OS and ACE 11 version.

    ------------------------------
    Jothiboss Murugan
    ------------------------------



  • 4.  RE: Add more than one ODBC connection to same Integration node

    Posted Fri February 25, 2022 04:14 AM
    Hi again.
    Have you solved the issue yet?

    If not, here are two things worth checking out. It seems from the command that you have an integration node with a server? 

    If so:
    1. You can try to run the following:  mqsireportdbparms appconnect-test -n odbc::* this will list the credentials that are correctly set.
    2. I thought you had to issue the mqsisetdbparms like this: mqsisetdbparms appconnect-test -n odbc::SQLDSN-u sa -p ****** It might be worth trying out. 
    3. Also - all commands are run as the same user that runs ACE?

    Cheers,
    Lars


    ------------------------------
    Lars Dehli
    ------------------------------



  • 5.  RE: Add more than one ODBC connection to same Integration node

    Posted Fri February 25, 2022 04:51 AM
    Hello,

     From the initial description you're expecting a database called "XCBDB" but the command pasted above is for "XCPDB" instead (a "P" instead of a "B") and that could lead to the error you see.