| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| compute node data source definition |
« View previous topic :: View next topic » |
| Author |
Message
|
| adars1 |
 Posted: Thu Nov 03, 2011 10:10 am Post subject: compute node data source definition |
 |
|
Apprentice
Joined: 13 Jun 2010
Posts: 39
|
From compute node, I am inserting data into sql server table.
in compute node Data source property, given data source name and from esql called(INSERT INTO Database.dbp.BData()VALUES() ) to insert into table. Defined the data source in broker system dsn, and given properties(SQL Server authenticationusing login id entered by user) user,pwd,sql server host and database name.
When flow writing data to sql server table, broker using the broker service id for authentication, not the user/pwd defined in data source dsn.
Do I still need to run mqsisetdbparms command to setup data source ? |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Thu Nov 03, 2011 10:21 am Post subject: Re: compute node data source definition |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| adars1 wrote: |
| Do I still need to run mqsisetdbparms command to setup data source ? |
i assume that you have not executed this command in your broker isnt it.
if not, please do so, its required.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| 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
|
|
|
|
