MQSeries.net :: View topic - Problem with ODBC

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem with ODBC

Problem with ODBC

« View previous topic :: View next topic »

Author

Message

LH33

Posted: Wed Mar 14, 2007 9:46 am Post subject: Problem with ODBC

Master

Joined: 21 Nov 2002
Posts: 200

I am having a problem with messages erroring out as soon as they hit the input queue of my message flow. The error it is giving is:

parameter 1 = 28000parameter 2 = 1017parameter 3 = [DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied

The ODBC connection has been changed and the data source in the flow has been changed to reflect the change in ODBC connection.

A new message flow has been created in the same execution group which just tests the ODBC connection and this flow works successfully.

I wanted to see if anyone has any ideas of what may be wrong?

Thanks!

elvis_gn

Posted: Wed Mar 14, 2007 10:02 am Post subject: Re: Problem with ODBC

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi LH33,

LH33 wrote:

parameter 1 = 28000parameter 2 = 1017parameter 3 = [DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied

The ODBC connection has been changed and the data source in the flow has been changed to reflect the change in ODBC connection.

Try the mqsisetdbparms

LH33 wrote:

A new message flow has been created in the same execution group which just tests the ODBC connection and this flow works successfully.

Whats the difference in this flow and the one where ur getting the error ? If this flow works, then any flow in the same broker, using the same datasource name should also work...

Regards.

LH33

Posted: Wed Mar 14, 2007 10:06 am Post subject:

Master

Joined: 21 Nov 2002
Posts: 200

HI! I agree.

The difference is a lot of data transformations and six route to labels.

I just commented out the call to the database in the flow that's causing the error and it works... ??

I don't know what else to try now. Any suggestions?

tillywern

Posted: Wed Mar 14, 2007 1:26 pm Post subject: Tools

Centurion

Joined: 28 Jan 2003
Posts: 109
Location: Colorado

If you use mqsisetdbparams and the user name and password are still trouble, look for a tool to help exercise odbc.ini.

isql or Open ODBC have tools that will exercise your configuration but won't troubleshoot values that MQSI manages. isql will allow you to test the odbc stanza that are in your config file though.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem with ODBC

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