| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Can not access sybase data source in compute node |
« View previous topic :: View next topic » |
| Author |
Message
|
| george_king |
 Posted: Thu Mar 17, 2005 7:19 am Post subject: Can not access sybase data source in compute node |
 |
|
Newbie
Joined: 17 Mar 2005
Posts: 6
|
| I try to access sybase data source in compute node. I'v create new DSN in data source and use mqsisetdbparam set user password. But it can not work. A strange thing is, when I use a username without password, it can work. Who can tell me how to resolve the problem. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Mar 17, 2005 7:20 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
How do you know it does not work? What error messages are produced?
Does the broker service user have different authorities on the database than the broker database user?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| george_king |
| Posted: Thu Mar 17, 2005 7:00 pm Post subject: |
|
|
Newbie
Joined: 17 Mar 2005
Posts: 6
|
| When debug into the compute node, a SQLException was threw to say that connection can not be established. What do you mean about "broker service user have different authorities"? the broker itself use DB2, but our msg flow use sybase. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Mar 18, 2005 5:41 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
When you create a broker, there are two users that are passed to mqsicreatebroker. One is the broker service user, one is the broker database user.
Using mqsisetdbparms allows you to use a DIFFERNT user for user databases than either of those two users.
The question I was asking was if either of those two users also had access to your SYBASE database - and if they had different permissions than the user you set up with mqsisetdbparms.
Can you establish the ODBC connection from the OS, rather than from inside the broker?
Are there errors in SYBASE that occur when you try to connect from the broker?
_________________
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
|
|
|
|
