ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker ODBC Connection not working

Post new topic  Reply to topic
 Broker ODBC Connection not working « View previous topic :: View next topic » 
Author Message
elvis_gn
PostPosted: Thu Sep 24, 2009 1:33 am    Post subject: Broker ODBC Connection not working Reply with quote

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
Hey guys,

I'm facing a strange issue...

I have an oracle server db on a laptop (say 1st), and I have oracle client, Toad and Broker on laptop 2.

I've set the tnsnames on 2nd and am able to do all possible db work with the Toad, which means tns connectivity works.

I've also done the DSN and mqsisetdbparms for the broker.

Now irrespective of whatever I do with the broker...i.e run a proper sql in esql OR give wrong dsn name on compute properties OR wrong table name OR wrong userid/pwd in mqsisetdbparms....for nothing do I get any successful rows back or a database exception.

And yes, i'm deploying the correct flow and the execution is passing across the sql as my output tree structure is appearing.

What have I missed ?

Regards.
Back to top
View user's profile Send private message Send e-mail
Gaya3
PostPosted: Thu Sep 24, 2009 2:01 am    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
I am not sure whether you have done this


Clean up the project
Remove the deployed childern from EG
Deploy the new Flow and Code and Test the same.



ideally it should throw an exception, but lets see what could be the issue atleast by digging in to this.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker ODBC Connection not working
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.