| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Access multiple databases - URGENT |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqs_guy |
 Posted: Thu May 27, 2004 3:12 pm Post subject: Access multiple databases - URGENT |
 |
|
Acolyte
Joined: 09 May 2002
Posts: 71
|
Hi,
I have a need to access another database(oracle) say APP1, apart from the one i have for my broker say DB1.
I have added that database which i need to access in the .odbc.ini file.
Now my .odbc.ini file has 2 entries, 1 for DB1(broker db) and other for APP1 (application DB)
Now when i created the broker using the mqsicreatebroker command i used a userid and pwd to connect to the broker database DB1. I dont have that userid defined on the database APP1.
Questions:
1) Do i need to define the same userid on database APP1, as that on database DB1 when i created the broker?
2) If no, how will the broker know the connection params?
3) i used a compute node to access database APP1 and it wouldn't work. When did a trace, it gives me BIP2599 and doesn't say anything abt database error or security error. It says the ESQL syntax is invalid.
If i use the same ESQL with database DB1, it works fine.
As always, your inputs are highly appreciated.
Thanks & Regards,
Vishal Agrawal |
|
| Back to top |
|
 |
| vallu |
| Posted: Thu May 27, 2004 3:46 pm Post subject: |
|
|
Apprentice
Joined: 29 Jun 2002
Posts: 31
|
1) Do i need to define the same userid on database APP1, as that on database DB1 when i created the broker?
NO. Not necessary.
2) If no, how will the broker know the connection params?
Create a user in the oracle db with the same broker machine Userid that you use to logon to.
Vallu |
|
| Back to top |
|
|
| mqs_guy |
| Posted: Thu May 27, 2004 5:16 pm Post subject: |
|
|
Acolyte
Joined: 09 May 2002
Posts: 71
|
Thanks Vallu for your instant reply.
Correct me if 'am wrong.."should i create the same user id under which my broker is running" under the database APP1?..meaning the one i used when i created the broker..the "-u parameter"!!
Do you think that if i have these two things being..
1) userid under which my broker is running in database APP1
2) an entry in the .odbc.ini file for the database APP1
I should be able to access the database APP1 using the compute node?
Whts bothering me is the usertrace..it doesn't show up any ODBC (database) security error!! It says ESQL is invalid and that's not true..
Can post the esql too if needed.
Thanks in advance.
Cheers,
Vishal Agrawal |
|
| Back to top |
|
|
| JT |
| Posted: Thu May 27, 2004 6:30 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
mqs_guy,
Are you using v2.1 or v5.0? Under v5.0 you can set a unique userid for each Oracle schema/data source you specify in the .odbc.ini file. This is accompished using the mqsisetdbparm command:
| Code: |
| mqsisetdbparm Broker_Name -n APP1 -u userid -p password |
If I remember correctly, in v2.1 the userid used to access user databases was the same userid defined on the mqsicreatebroker command. |
|
| Back to top |
|
|
| mqs_guy |
| Posted: Tue Jun 01, 2004 9:53 am Post subject: Access multiple databases - URGENT - Resolved |
|
|
Acolyte
Joined: 09 May 2002
Posts: 71
|
Thanks JT. It worked!!
'Am using WBI 5.0 and when i issued the command:
mqsisetdbparm Broker_Name -n APP1 -u userid -p password
i was able to access the database APP1 using the new userid and pwd using the compute node.
Guys, thanks again for your inputs and support.
Cheers,
Vishal Agrawal |
|
| 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
|
|
|
|
