You cannot specify a username and password with the MQ endpoint as you can using TIBCO JMS. All connections to the MQ Queue Manager are made as the user that the Adaptive Server process is running as. After making the connection to the MQ Queue Manager, Adaptive Server then attempts to open the queue as the Adaptive Server login that is performing the operation. For this reason, the user must:
Have a user account on the machine on which MQ Queue Manager is running
Be an MQ user
Have the MQ authorizations listed in Table 2-3.
The Adaptive Server “messaging_role” is
still required to execute Real Time Data Services built-in
functions.
In addition, the ‘register, login' and 'default, login' functions of sp_msgadmin do not allow you to register Adaptive Server logins, or to create default Adaptive Server logins if the endpoint specified is a Queue Manager. See sp_msgadmin for more information about sp_msgadmin.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |