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 » Setting up ODBC.INI

Post new topic  Reply to topic
 Setting up ODBC.INI « View previous topic :: View next topic » 
Author Message
dextermbmq
PostPosted: Tue Dec 22, 2015 2:19 pm    Post subject: Setting up ODBC.INI Reply with quote

Voyager

Joined: 26 Jul 2014
Posts: 77
Hello All,

I am facing an issue in setting up Odbc env for one of my DSNs in IIB 9 Env. I have setup the DSNs successfully for some the ORACLE DB DSNs where we were using SERVICE NAME in the corresponding DSN stanza.

EXAMPLE :

[XXXXXX]
Driver=/opt/ibm/mqsi/9.0.0.4/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=XXXXXXXXXXX
PortNumber=1521
ServiceName=EBDV


Now I need to set up DSN STANZA for a DSN where we need to specify SID in place of SERVICE NAME. I created a DSN with below info :

[XXXXX]
Driver=/opt/ibm/mqsi/9.0.0.4/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=XXXXXXXXX
PortNumber=1521
SID=OPTST11


Finally after mqsisetdbparms when i did mqsicvp the BROKER-DB connectivity worked fine. Everything was going smooth until application starting using this DSN. The application is getting below error :

<Message>Child SQL exception; IM002; 0; [unixODBC][Driver Manager]Data source name not found, and no default driver specified</Message>

Now , I have verified that the DSN entry in the COMPUTE AND DATABASE NODE is correct. I am not sure why are we facing this issue. I deliberately raised the SID-SERVICE NAME point as I suspect it to be the cause(since whichever DSN entries are configured with SERVICE NAME are working fine)

Also , I have noticed while working on IIB 10 that there are scenarios that MQSICVP works fine but due to BROKER CONFIGURATION issue the applications faile to connect with the DB giving above error--This point has made me confident the error is not on DEV SIDE but with some configuration issue at ADMIN side


Kindly assist

Thanks
Back to top
View user's profile Send private message
smdavies99
PostPosted: Tue Dec 22, 2015 11:35 pm    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
I would look at doing the mapping between a service name and the SID in the tnsnames.ora rather than in the ODBC config.

Create a new tnsnames stanza with a new service name and define the SID in that.

with the changes you described, does the mqsicvp command work?
If that does not work then IMHO, there is little point in trying it from a message flow.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
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 » Setting up ODBC.INI
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.