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 » [DataDirect][ODBC lib] Data source name not found..

Post new topic  Reply to topic
 [DataDirect][ODBC lib] Data source name not found.. « View previous topic :: View next topic » 
Author Message
brokerDev
PostPosted: Fri Jan 26, 2007 9:14 am    Post subject: [DataDirect][ODBC lib] Data source name not found.. Reply with quote

Acolyte

Joined: 21 Jun 2006
Posts: 53

Hi,

I am getting the following error in a compute node when trying to access a database. The error is:

Quote:
[DataDirect][ODBC lib] Data source name not found and no default driver specified


We are using WMB v5 on an AIX platform.

I have entered the relevant datasource name against the properties of the node. I have also ran the mqsisetdbparms command to assign the username and password. The tnsnames entry has also been created.

I can connect to the the DB from broker using sqlplus 'user'/'pwd'@schema

I can also tnsping the DB ok.

Any suggestions on what else I can do to troubleshoot?

Thanks
Back to top
View user's profile Send private message
elvis_gn
PostPosted: Fri Jan 26, 2007 9:18 am    Post subject: Reply with quote

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi brokerDev,

What driver did you use to create the System DSN...?

Regards.
Back to top
View user's profile Send private message Send e-mail
brokerDev
PostPosted: Fri Jan 26, 2007 9:26 am    Post subject: Reply with quote

Acolyte

Joined: 21 Jun 2006
Posts: 53

Hi elvis_gn,

Not sure I understand the question....I got this bit of info from the .odbc.ini file though. Is this what you meant?

Driver=/usr/opt/wmqi/merant/lib/UKor818.so

Regards,
Back to top
View user's profile Send private message
elvis_gn
PostPosted: Fri Jan 26, 2007 9:44 am    Post subject: Reply with quote

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi brokerDev,

You should go to the control Panel-> Administrative Tasks->ODBC and make a new System DSN entry for your database...you can test the connection using the userId and password from there itself...

THAT is the datasource name that you should use in the Compute node properties...

Regards.
Back to top
View user's profile Send private message Send e-mail
jefflowrey
PostPosted: Fri Jan 26, 2007 9:47 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

What does the [ODBC] section of the odbc.ini file say?
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
brokerDev
PostPosted: Fri Jan 26, 2007 10:06 am    Post subject: Reply with quote

Acolyte

Joined: 21 Jun 2006
Posts: 53

Hi elvis_gn,

I have performed a test connection from my local desktop as you suggested and I got a successful connection using the datasource name that I have used in the compute node properties. I still get the odbc error in broker though.



Hi jefflowrey,

The ODBC section of the .odbc.ini says -

[ODBC Data Sources]
MQSIBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 410 Oracle 8 Driver
SYBASEDB=DataDirect 410 Sybase ASE Driver

Regards,
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Fri Jan 26, 2007 10:13 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

There should be an entry in there for your DSN name, that equals the same value as ORACLEDB does.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
brokerDev
PostPosted: Fri Jan 26, 2007 10:59 am    Post subject: Reply with quote

Acolyte

Joined: 21 Jun 2006
Posts: 53

Have tried that but I'm afraid I'm still getting the error. Besides, we access other databases and we do not have entries for them in the .odbc.ini file.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Fri Jan 26, 2007 11:05 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You have to have an ODBC entry for any access to a database from ESQL, as Broker uses ODBC to access all databases.

You have to follow all the correct procedures as outlined in the manuals for connecting to databases - this includes getting the ODBC entries in .odbc.ini correct.

For an Oracle datasource, you also need to EnableSQLDescribeParam.

And you may need to also source the Oracle db profile into the broker service user's environment.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
brokerDev
PostPosted: Fri Jan 26, 2007 11:46 am    Post subject: Reply with quote

Acolyte

Joined: 21 Jun 2006
Posts: 53

Hi jefflowrey,

Many thanks for you forbearance. You were of course right.

I was looking at .odbc.ini in /var/mqm/odbc and that's why I coudn't see all the other DSNs. I've now edited /home/'broker'/.odbc.ini and we're 'cooking with gas'.

Regards,
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 » [DataDirect][ODBC lib] Data source name not found..
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.