| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing DB2 in a AS/400 by WMQI v2.1 |
« View previous topic :: View next topic » |
| Author |
Message
|
| miguelanselmo |
 Posted: Tue Oct 28, 2003 3:08 am Post subject: Accessing DB2 in a AS/400 by WMQI v2.1 |
 |
|
Novice
Joined: 28 Oct 2003
Posts: 15
|
Hi,
I'm trying to access a DB2 in a OS/400 v5, but i'm getting this error
"[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason ("USERID INVALID"). SQLSTATE=08001"
I'm using WMQI v2.1 in Windows 2000. I create a ODBC connection with the DB2 driver and the test was sucessfully. In my message flow a "add" the name of the ODBC source created. This message flow only have a mqinput a compute node and 2 mqoutput (for ok and error).
My broker run as windows service using the user that have permissions to access the database (used when creating the ODBC).
Can any body help me with this problem and tell me what I'm douing wrong.
Thanks in advance,
Miguel Anselmo |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Oct 28, 2003 5:50 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
All (well, mostly) database connections in WMQI are made using the 'database user', and not the 'service user'.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| miguelanselmo |
| Posted: Tue Oct 28, 2003 7:37 am Post subject: |
|
|
Novice
Joined: 28 Oct 2003
Posts: 15
|
Hi Jeff,
what user is used by WMQI. Where is defined this user?
Thanks in advance,
Miguel Anselmo |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Oct 28, 2003 8:24 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| miguelanselmo wrote: |
Hi Jeff,
what user is used by WMQI. Where is defined this user? |
There are two user ids specified when you run mqsicreatebroker.
One of these userid's is the 'Service User'. The other is the 'Database User'.
When a particular broker accesses any database, it uses the 'Database user' that was specified when that broker was created.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| miguelanselmo |
| Posted: Tue Oct 28, 2003 10:36 am Post subject: |
|
|
Novice
Joined: 28 Oct 2003
Posts: 15
|
Jeff,
thank you for your help. The problem is resolved
Miguel Anselmo |
|
| 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
|
|
|
|
