MQSeries.net :: View topic

gobi_nathan · Posted: Thu Jul 29, 2004 3:24 am Post subject:

Hi All,

On Solaris, i have WMQIB5 ,CSD03 and Oracle9i(9.2.0.1).
I am trying to create a broker and it is giving me a database error.

I have done the following
Run the "mqsi_setupdatabase" and it has created the links.

Changed values in /var/wmqi/odbc/.odbc.ini pointing to my "DSN" which is up and running

Following is my .odbc.ini file

TESTDB=MERANT 3.70 Oracle 8 Driver

[TESTDB]
Driver=/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=TESTDB
LogonID=dbm
Password=dmb
EnableDescribeParam=1
OptimizePrepare=1

I am getting the folloing error message.. when i try to create Broker

AMQ8110: WebSphere MQ queue manager already exists.
WebSphere MQ queue manager running.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
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 'IM003'; Native Error Code '80'; Error Text
'Specified driver could not be loaded'.
The error has the following diagnostic information: SQL State 'I
M003' SQL Native Error Code '80' SQL Error Text 'Specified driver
could not be loaded'
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.

I saw the same issue is already posted before in the forum.Since i haven't find any helping answer and hope those who already fixed the issues can update the solution.Sorry i am posting this again.

Regards,
Gobi