| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Getting this 'SQLSTATE=42705' from Message Broker |
« View previous topic :: View next topic » |
| Author |
Message
|
| venkat_chekka |
 Posted: Mon Oct 19, 2009 9:03 am Post subject: Getting this 'SQLSTATE=42705' from Message Broker |
 |
|
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 |
|
 |
| vairavan |
| Posted: Mon Oct 19, 2009 9:20 am Post subject: |
|
|
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 |
|
|
| venkat_chekka |
| Posted: Mon Oct 19, 2009 10:48 am Post subject: |
|
|
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 |
|
|
| mqjeff |
| Posted: Mon Oct 19, 2009 11:28 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| What does the DB2 documentation say is the cause of that SQL state? |
|
| Back to top |
|
|
| dk27 |
| Posted: Mon Oct 19, 2009 1:47 pm Post subject: |
|
|
Acolyte
Joined: 28 Apr 2008
Posts: 51
|
| also you may need to check entry in odbc ini file |
|
| 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
|
|
|
|
