MQSeries.net :: View topic - DB Username Password

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 » DB Username Password

DB Username Password

« View previous topic :: View next topic »

Author

Message

madi

Posted: Tue Feb 28, 2006 12:32 pm Post subject: DB Username Password

Chevalier

Joined: 17 Jan 2006
Posts: 475

Hi All

I am trying to connect to a DB2 database on AS/400 in the database node.

I have created an odbc connection.

Now the username and password that I have for the database are different from the ones that I created the broker with.

I have put in the new username and password in the Configure option in the SYS DSNs when I created the ODBC connection.

When I try to get data from the DB I get an error saying the username and password are incorrect.

I there any place else that I have to mention the usename/pswd.

THis is the error that i get:

Code:

Database error: SQL State '08001'; Native Error Code '-30082'; Error Text '[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 '.

The error has the following diagnostic information: SQL State '08001' SQL Native Error Code '-30082' SQL Error Text '[IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 '

plz help
madi

wschutz

Posted: Tue Feb 28, 2006 1:29 pm Post subject:

Jedi Knight

Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)

Quote:

I have put in the new username and password in the Configure option in the SYS DSNs when I created the ODBC connection.

do you mean on the windows odbc datasource administrator applet? I think the user/password there is only for testing the connection... have you set the userid/password via the mqsisetdbparms command?
_________________
-wayne

madi

Posted: Tue Feb 28, 2006 1:33 pm Post subject:

Chevalier

Joined: 17 Jan 2006
Posts: 475

If we set the db username/[assword that way are we changing the broker database?

Or are we jsut giving the params for another database we would like to access through the broker?

--madi

EddieA

Posted: Tue Feb 28, 2006 3:13 pm Post subject:

Jedi

Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles

Quote:

If we set the db username/password that way are we changing the broker database?

No.

Quote:

Or are we just giving the params for another database we would like to access through the broker?

Yes.

Always assuming that you are not running 2.1, where you can only use a single username/password for all the DBs accessed.

BTW Looking up the command in the manual would have got you the answer a lot quicker than posting a question here.

Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB Username Password

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