WebSphere Message Broker Configures ODBC connection (Oracle)

Source: Internet
Author: User
Tags dsn odbc connection

1. Windows Environment Configuration

Steps:

1. Click Start > Control Panel > Administrative Tools > Data source (ODBC)

2. Click the System DSN tab and click Add

3. Configure new DSN



4. Turn off ODBC Configuration, modify registry Click Start > run input REGEDIT, and click OK.

Open in Registry Editor,

Browse to : Hkey_local_machine\software\odbc\odbc. INI , locate the new DSN, and right-click the DSN entry. Select New > string value.

string: Workarounds values: 536870912 Close Registry Editor.

5. Open the ESB command line execution command:mqsisetdbparms blesb2-n myoracledb-u BLGROUP_OSP- P BLGROUP_OSP. where BLESB2 refers to the borker name,-nmyoracledb refers to the data source name, -ublgroup_osp refers to Oracle user name. - P blgroup_osp refers to the password. Successful execution,ODBC configuration succeeded.

2. Linux Environment Configuration

1. find esb installation directory /opt/ IBM/MQSI/9.0/ODBC/UNIXODBC odbc.ini                      Odbcinst.ini Span style= "" > file Copy to /home/wbiadmin/odbc (CP Odbc.ini                                    /home/wbiadmin/odbc,   CP Odbcinst.ini home/wbiadmin/ ODBC )

2. modified odbc.ini to:# Oracle Stanza

[Myoracledb] ( data source name )

Driver=/opt/ibm/mqsi/9.0/odbc/v7.0/lib/ukora26.so

Description=datadirect ODBC 7.0 Oracle wire Protocol

hostname=192.168.100.104 ( Oracle HOST )

portnumber=1521 ( Oracle Port)

SERVICENAME=ORCL (service name)

Catalogoptions=0

Enablestaticcursorsforlongdata=0

Applicationusingthreads=1

Enabledescribeparam=1

Optimizeprepare=1

workarounds=536870912

Procedureretresults=1

Columnsizeascharacter=1

Logintimeout=0

[ODBC]

installdir=/opt/ibm/mqsi/9.0/odbc/v7.0 ( ESB installation directory)

Usecursorlib=0

Ianaappcodepage=4

Unicode=utf-8

3. Modify odncinst.ini to

Trace=no

Tracefile=/home/wbiadmin/odbctrace.out ( Trace output directory)

threading=2

4. to Odbc.ini, Odbcinst.ini Assign user groups (ESB users)

command:chown-r wbiadmin.wbiadmin/home/wbiadmin/odbc

5. config odbc environment variable, navigate to /var/mqsi/common/profiles modify suffix .sh                odbcini and odbcsysini (note odbcini The variable value of           to odbc.ini file, odbcsysini odbcinst.ini file directory


6. Close the command window and reopen the command window to test whether the environment variable is configured correctly. Navigate to /var/mqsi/common/profiles. Use ./opt/ibm/mqsi/9.0/bin/mqsiprofile detection. (Note: Each command window can be detected only once.) )。

7. After successful detection, switch to ESB user execution command:mqsisetdbparms blesb2-n myoracledb-u Blgroup_osp-p Blgroup_osp. where BLESB2 refers to the borker name,-nmyoracledb refers to the data source name, -ublgroup_osp refers to the Oracle user name. - P blgroup_osp refers to the password. Successful execution,ODBC configuration succeeded.

Note: The configuration must be restarted after completion Broker, Command (mqsistop BLESB2 mqsistart BLESB2) .

Reference Documentation:

Http://www-01.ibm.com/support/knowledgecenter/SSMKHH_9.0.0/com.ibm.etools.mft.doc/bk58060_.htm?lang=zh


WebSphere Message Broker Configures ODBC connection (Oracle)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.