MQSeries.net :: View topic - how to access Remote database

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to access Remote database

how to access Remote database

« View previous topic :: View next topic »

Author

Message

cute_pav

Posted: Mon Sep 30, 2002 4:59 am Post subject: how to access Remote database

Acolyte

Joined: 04 Jan 2002
Posts: 65
Location: usa

Hi,

I have an environment set up
with broker database as DB2 in solaris.ConfigMgr in win2000 with DB as DB2.I want to connect to Oracle database for inserting SQL queries.
Is that possible? if so, would like to know how can I connect to remote database (Oracle).
Is that .ODBC.ini details are applicable to connect to remote database or is that only for BrokerDatabase setup?

marko

Posted: Mon Sep 30, 2002 6:45 am Post subject:

Apprentice

Joined: 28 Feb 2002
Posts: 27

Add an entry in .odbc.ini for your oracle database. Then use the name of the entry as your datasource when you configure a Compute/Database node. The trick is to keep in mind that the broker will access your Oracle database using the same userid/password that is being used for the Broker database.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to access Remote database

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP