| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| problem using MQSeries Meant 3.70 -BIT oracle8 |
« View previous topic :: View next topic » |
| Author |
Message
|
| artham |
 Posted: Fri Mar 14, 2003 8:36 am Post subject: problem using MQSeries Meant 3.70 -BIT oracle8 |
 |
|
Novice
Joined: 13 Feb 2002
Posts: 12
|
I get the following error when i am using the above specified drivers its workin fine if i use oracle driver.
See the following messages for details of the error.
2003-03-14 11:19:41.264999 4528 RecoverableException BIP2519E: (1, 1) : Error executing SQL statement 'SELECT UI.user_id FROM um.userinfo UI WHERE (UI.login)=(?)' against datasource 'x' with parameters ''BDMOBU01', '.
The following error occurred during execution of a database SQL statement against datasource 'x'. The SQL statement was 'SELECT UI.user_id FROM um.userinfo UI WHERE (UI.login)=(?)'. The parameters passed were ''BDMOBU01', '.
2003-03-14 11:19:41.264999 4528 DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
2003-03-14 11:19:41.264999 4528 DatabaseException BIP2322E: Database error: SQL State 'IM001'; Native Error Code '0'; Error Text '[Microsoft][ODBC Driver Manager] Driver does not support this function'.
The error has the following diagnostic information: SQL State 'IM001' SQL Native Error Code '0' SQL Error Text '[Microsoft][ODBC Driver Manager] Driver does not support this function'
I do want to use the driver given by MQSI 2.1 can somebody help me solve this .
Its sought of urgent.
kiran |
|
| Back to top |
|
 |
| Ian |
| Posted: Mon Mar 17, 2003 6:14 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Hi "artham",
When configuring WMQI and Oracle and an error is returned with a 'Driver does not support this function'
then typically the reason is that you have not enabled "SQLDescribeParam".
Refer to the WMQI Admin Guide, Chapter 3, Defining an ODBC connection for the broker database
(which is also applicable for a user database), ODBC on Windows NT, Oracle 8
- Under the Advanced tab of the driver settings, ensure that the Enable SQLDescribeParam box is checked.
Your error also shows you are using passed in parameters which requires this functionality.
| Quote: |
Error executing SQL statement 'SELECT UI.user_id FROM um.userinfo UI WHERE (UI.login)=(?)' against datasource 'x' with parameters ''BDMOBU01'
|
_________________
Regards, Ian |
|
| Back to top |
|
|
| artham |
| Posted: Mon Mar 17, 2003 8:01 am Post subject: |
|
|
Novice
Joined: 13 Feb 2002
Posts: 12
|
thanks a lot .
works like a champ. |
|
| Back to top |
|
|
| artham |
| Posted: Mon Mar 17, 2003 8:20 am Post subject: |
|
|
Novice
Joined: 13 Feb 2002
Posts: 12
|
| can i use the same ODBC driver with Oracle 9i even though it says its for oracle 8 |
|
| Back to top |
|
|
| Ian |
| Posted: Tue Mar 18, 2003 7:22 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Yes, you can use WMQIv2.1 with Oracle 9iR1 (9.0.1) using the WMQI supplied "MERANT 3.70 Oracle8 Driver".
_________________
Regards, Ian |
|
| 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
|
|
|
|
