| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL Connection Error to ODBC |
View previous topic :: View next topic |
| Author |
Message
|
| Matrin |
 Posted: Mon Feb 25, 2008 2:32 am Post subject: ESQL Connection Error to ODBC |
 |
|
Novice
Joined: 14 Feb 2008
Posts: 10
|
Hello foldks, can I use your expertise in the following scenario:
I’m using IBM Message Broker to connect to an SQL server on the network. However, the queue throws the following excpetion:
(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 = '18456'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'wbimbadm'.'
And sometimes it throws:
(0x03000000):Text = 'The ESQL deployed to the node is invalid.'
I found the user “'wbimbadm'” on the MQ server
I tried creating the ODBC on the MQ server I am deploying to and managed to connect to the SQL server successfully! I even created the same ODBC connection on my machine!
I am sure it’s an access issue but can’t figure it out.
Please help  |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Mon Feb 25, 2008 2:52 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
Whats the need of double posting,....
Dont do it
Error is very descriptive tooo...
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| Matrin |
| Posted: Mon Feb 25, 2008 3:08 am Post subject: |
|
|
Novice
Joined: 14 Feb 2008
Posts: 10
|
Hey,
I placed the first posting in the wrong place..
sorry |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Feb 25, 2008 3:18 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Matrin wrote: |
Hey,
I placed the first posting in the wrong place..
sorry |
If it happens again, leave it an admin will move it. 
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
