| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| accessing external ORACLE database from MQSI |
« View previous topic :: View next topic » |
| Author |
Message
|
| kwelch |
 Posted: Wed Jan 09, 2002 11:56 am Post subject: |
 |
|
Master
Joined: 16 May 2001
Posts: 255
|
I have read several postings about accessing external databases from MQSI and am still experiencing problems. MQSI is on an NT box. We have ORACLE 8.1. The SA has set up an ODBC connection on the box where MQSI lives. The ORACLE DBA has added the ID and password that were used to create the broker. We are able to connect to the database outside of MQSI but once MQSI is added to the mix we get invalid userid and password. Does anyone know of a way to display the id and password that MQSI is passing?
Any ideas or thoughts are greatly appreciated.
Karen |
|
| Back to top |
|
 |
| kirani |
| Posted: Wed Jan 09, 2002 4:47 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Karen,
MQSI uses DatabaseUserID and DatabasePassword (supplied with mqsicreatebroker command) to make any connection to the external database. It completly ignores the database user-id/password supplied with the DSN or in .odbc.ini file.
For example, If you are using following command to create a broker,
mqsicreatebroker MQSIBK -i MQADM -a MQADM -q MQSIV2 -n MQSIBKDB -u db2admin -p db2admin
In ORACLE database, you should create a user-id/password as db2admin/db2admin
If you did not specify '-u' and '-p' parameters in 'mqsicreatebroker' command, mqsi will use service user-id/password (in this case, MQADM/MQADM) to make any database connections.
Hope this helps!
Regards,
Kiran
|
|
| Back to top |
|
|
| kwelch |
| Posted: Thu Jan 10, 2002 7:10 am Post subject: |
|
|
Master
Joined: 16 May 2001
Posts: 255
|
Thanks. As it turns out the password that was used to create the broker had a special character in it which ORACLE did not like. The password had to be changed and now we have gotten passed the password problem.
Karen |
|
| 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
|
|
|
|
