MQSeries.net :: View topic - How do I connect from the broker machine out to a remote db?

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 do I connect from the broker machine out to a remote db?

How do I connect from the broker machine out to a remote db?

« View previous topic :: View next topic »

Author

Message

vinze

Posted: Thu Apr 04, 2002 10:09 am Post subject:

Newbie

Joined: 11 Mar 2002
Posts: 3

I have a 202 broker on Solaris, running Oracle 817. I wish to connect out from the broker to another database running on another machine. I know I have to update the /var/mqsi/odbc/.odbc.ini file. But how do I tell the definitiions in the .odbc.ini file that the application database is on a nother machine? Do I need to mess around with tnsnames.ora????

Please help!!!

rwa

Posted: Tue Apr 09, 2002 3:12 am Post subject:

Voyager

Joined: 22 Jan 2002
Posts: 76
Location: Duesseldorf/Germany

The configuration in odbc.ini related to a local data source definition. This
data source is defined with an database access client (like SQL*Net) on your machine. The local data source definition can point to a local or remote database. tnsnames.ora is used on an Oracle client. A catalog entry is used by db2 (please read the db2 docs).

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How do I connect from the broker machine out to a remote db?

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