{"id":536,"date":"2016-03-10T23:36:42","date_gmt":"2016-03-10T18:06:42","guid":{"rendered":"http:\/\/www.middlewareprimer.com\/blog\/?p=536"},"modified":"2016-03-10T23:36:42","modified_gmt":"2016-03-10T18:06:42","slug":"iib-v9-odbc-configuration-setup","status":"publish","type":"post","link":"http:\/\/www.middlewareprimer.com\/blog\/2016\/03\/10\/iib-v9-odbc-configuration-setup\/","title":{"rendered":"IIB v9 ODBC Configuration Setup"},"content":{"rendered":"<p>IIB v9 ODBC Configuration Setup needs to be followed as mentioned in the v9 Knowledge Center.\u00a0 Please follow the right set of configuration for each of the Database setup.<\/p>\n<p>1. Setup the ODBCINI path pointing out to ODBC.ini and ODBCINST.ini.<\/p>\n<p>Database information will go and reside in ODBC.ini and Trace path information will be setup in ODBCINST.ini which is used for initializing. Provide valid paths for database.<\/p>\n<p>2. Use <span class=\"keyword cmdname\">mqsisetdbparms<\/span> command to setup the database parameter<\/p>\n<p>3. Use mqsicvp command to check for Database connection<\/p>\n<p><a href=\"https:\/\/www.ibm.com\/support\/knowledgecenter\/SSMKHH_9.0.0\/com.ibm.etools.mft.doc\/bk58070_.htm\" target=\"_blank\">https:\/\/www.ibm.com\/support\/knowledgecenter\/SSMKHH_9.0.0\/com.ibm.etools.mft.doc\/bk58070_.htm<\/a><\/p>\n<p>NOTE: SQL Server driver <span class=\"ph filepath\">UKsqls26.so<\/span> was introduced with <span class=\"ph\">IBM Integration Bus<\/span> V9.0.0.3. If you are at an earlier version than V9.0.0.3, SQL Server driver <span class=\"ph filepath\">UKmsss26.so<\/span> should be used.<\/p>\n<p>Above Note is an important point while configuring on IBM Integration Bus v9.0.0.3 as it may lead to errors while connecting to the Database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>IIB v9 ODBC Configuration Setup needs to be followed as mentioned in the v9 Knowledge Center.\u00a0 Please follow the right set of configuration for each of the Database setup. 1. Setup the ODBCINI path pointing out to ODBC.ini and ODBCINST.ini. Database information will go and reside in ODBC.ini and Trace path information will be setup [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[146,145,144,147,148],"class_list":["post-536","post","type-post","status-publish","format-standard","hentry","category-ibm-integration-bus","tag-iib-v9","tag-iib-v9-odbc","tag-mqsicvp","tag-odbc-ini","tag-odbcinst-ini"],"_links":{"self":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/comments?post=536"}],"version-history":[{"count":3,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/536\/revisions"}],"predecessor-version":[{"id":539,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/536\/revisions\/539"}],"wp:attachment":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/media?parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/categories?post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/tags?post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}