| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [ODBC] Node connection to oracle - Invalid User and Password |
« View previous topic :: View next topic » |
| Author |
Message
|
| Janesd |
 Posted: Thu Feb 28, 2008 5:21 am Post subject: [ODBC] Node connection to oracle - Invalid User and Password |
 |
|
Newbie
Joined: 28 Feb 2008
Posts: 5
|
Hi all,
I have a node in the MQ message Broker Toolkit which connects to oracle using a system DSN on the IBM MQ server.
The problem is, that i keep on getting the following error;
'[DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied '
I am 100% sure that the user name and password are correct.
That drove me crazy 
do i have to give permession for the MQ or node to access the oracle database ? or what is happening ?
I have searched the net for answeres, but no luck 
Following is the trace
--------------------------
EXCEPTION TRACE:
(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x03000000):Line = 558
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'INT_REQ_ROUTER#FCMComposite_1_38.INT_TACS_REQ_RES#FCMComposite_1_8'
(0x03000000):Label = 'INT_REQ_ROUTER.GET_SUMMARY'
(0x03000000):Text = 'Node throwing exception'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 187
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Text = 'Root SQL exception'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2321
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-1'
)
(0x01000000):DatabaseException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x03000000):Line = 329
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Text = 'Child SQL exception'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '28000'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '1017'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '[DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied '
)
)
)
)
)
Anyone knows what is the problem ?
Thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Feb 28, 2008 5:35 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It will be helpful to learn the right terms here.
Your message flow (not your Toolkit) has a node that makes a database connection. Your message flow, when run on the Broker (not the MQ server), fails to connect to the database with the error message.
You are establishing a User Database connection. There are many many steps that need to be performed by the Broker administrator to do this. If you are doing this on your local workstation, then you need to perform these steps yourself.
The steps necessary to connect to a User Database are documented in the Info Center for Broker v6.1.
The step you have most likely forgotten is the one that uses mqsisetdbparms.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Janesd |
| Posted: Fri Feb 29, 2008 4:51 am Post subject: |
|
|
Newbie
Joined: 28 Feb 2008
Posts: 5
|
Thanks for your posting,
where can i get access to the Info Center you mentioned ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 29, 2008 5:05 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
|
| 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
|
|
|
|
