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 » Getting this 'SQLSTATE=42705' from Message Broker

Post new topic  Reply to topic
 Getting this 'SQLSTATE=42705' from Message Broker « View previous topic :: View next topic » 
Author Message
venkat_chekka
PostPosted: Mon Oct 19, 2009 9:03 am    Post subject: Getting this 'SQLSTATE=42705' from Message Broker Reply with quote

Apprentice

Joined: 14 Apr 2006
Posts: 37

Hi,

I have DB2 9.1 in my system and recently did install DB9.7 in my system as separate installation, so I have both DB2 9.1 and 9.7.

I have created table in DB2 9.7 database and did create DSN for that database but my broker unable to connect to that database. I have tested Data Source connectivity, it is connecting successfully.

I gave this DSN name at Compute node properties in my message flow but it is failing at Compute node.

Here is error I am getting at Compute node::

[IBM][CLI Driver] SQL1013N The database alias name or database name "XMLDBDSN" could not be found. SQLSTATE=42705

Could you help me why I am getting this type of error?

Thanks in Advance,
Venkat Chekka.
Back to top
View user's profile Send private message
vairavan
PostPosted: Mon Oct 19, 2009 9:20 am    Post subject: Reply with quote

Apprentice

Joined: 22 Apr 2008
Posts: 42

Have you set this DSN name to your broker?

If no, You can use mqsisetdbparms command.

mqsisetdbparms <brokername> -i <systemUser> -a <systemPassword> -n <DSN> -u <databaseUser> -p <databasePassword>

Hope this will resolve your problem.
Back to top
View user's profile Send private message
venkat_chekka
PostPosted: Mon Oct 19, 2009 10:48 am    Post subject: Reply with quote

Apprentice

Joined: 14 Apr 2006
Posts: 37

Hi,

I have set the DSN name in broker using mqsisetdbparms before itself but getting this error
Back to top
View user's profile Send private message
mqjeff
PostPosted: Mon Oct 19, 2009 11:28 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

What does the DB2 documentation say is the cause of that SQL state?
Back to top
View user's profile Send private message
dk27
PostPosted: Mon Oct 19, 2009 1:47 pm    Post subject: Reply with quote

Acolyte

Joined: 28 Apr 2008
Posts: 51

also you may need to check entry in odbc ini file
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 » Getting this 'SQLSTATE=42705' from Message Broker
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.