Posted: Wed Apr 26, 2006 4:00 pm Post subject: Problem in msg broker due to pw change
Newbie
Joined: 26 Apr 2006 Posts: 1
Hi,
I am new to WebSphere message broker & toolkit.
I installed WebSphere MQ, message broker & toolkit successfully.
I created artifacts required to run Pager Sample program. It did not work and meanwhile I had to change my machine password.
Many problems started with changing of the password. So, I completely re-install WebSphere MQ, Message Broker & Toolkit. Still get an error. Any help will be greatly appreciated.
Error:
C:\Program Files\IBM\MQSI\6.0>mqsideletebroker WBRK6_DEFAULT_BROKER
WebSphere MQ queue manager running.
BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. T
he ODBC return code was '-1'. See the following messages for information obtaine
d from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely t
o be such things as incorrect datasource or table names. Then correct either the
database or message broker configuration.
BIP2322E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text
''[Microsoft][ODBC Driver Manager] Data source name not found and no default dr
iver specified''.
The error has the following diagnostic information: SQL State ''
IM002'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][OD
BC Driver Manager] Data source name not found and no default driver specified''
This message may be accompanied by other messages describing the effect on the m
essage broker itself. Use the reason identified in this message with the accomp
anying messages to determine the cause of the error.
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the userid and password that were specified
when the broker was created.
Check that the database is running, that an ODBC connection has been created and
that the userid and password pair specified for ODBC connect on the mqsicreate
command are capable of being used to connect to the database using an ODBC conne
ction. Also ensure that the database has a adequate number of database connectio
ns available for use.
C:\Program Files\IBM\MQSI\6.0>mqsichangeusernameserver -i akale -a ram1sita
BIP8013E: Component does not exist.
A component may only be used if it has first been created.
No user action required.
Joined: 04 Aug 2004 Posts: 1213 Location: Hursley, UK
Go to Control panel -> Administrative Tools -> Services.
You need to change the password in each of the services definitions used by your broker, MQ and database.
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