| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Controlling message flow DB access |
« View previous topic :: View next topic » |
| Author |
Message
|
| KIT_INC |
 Posted: Thu May 10, 2007 9:20 pm Post subject: Controlling message flow DB access |
 |
|
Knight
Joined: 25 Aug 2006
Posts: 589
|
We are developing a message flow on WMB V6 which tries to access four Oracle DBs on 4 separate servers. We were wonderinf what userid and password will the compute nodes or DB nodes used to access these DBs. We prefer not to set up the same ID on the 4 systems. I am not a DBA. But I was told that we can use the userid and password specified in the DSN/ODBC driver. If that is the case, since nodes in MF are accessing DB through DSN, then the MF will be accessing the 4 DBs using 4 different IDs.
Is that right ? |
|
| Back to top |
|
 |
| marcin.kasinski |
| Posted: Thu May 10, 2007 10:53 pm Post subject: Re: Controlling message flow DB access |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
Yes.
Every DSN has own DB information (including userid and password).
_________________
Marcin |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Fri May 11, 2007 5:07 am Post subject: Re: Controlling message flow DB access |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
The broker does NOT make use of the userid/password specified in the ODBC driver. Instead, the mqsisetdbparms command is used at each broker to specify the userid/pwd associated with a DSN
_________________
Bill Matthews |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri May 11, 2007 5:11 am Post subject: Re: Controlling message flow DB access |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Bill.Matthews wrote: |
| The broker does NOT make use of the userid/password specified in the ODBC driver. Instead, the mqsisetdbparms command is used at each broker to specify the userid/pwd associated with a DSN |
That's not entirely true. It depends on the ODBC DSN. The DataDirect Driver for Oracle doesn't allow you to set a uid/password on the DSN. But last I knew, the Windows SQL Server ODBC Driver *does*, and Broker will use that if it's set.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
