| Author |
Message
|
| afzal |
 Posted: Tue May 08, 2007 6:26 am Post subject: Unable to connect to Oracle 9.2.0.6 from Message Broker 6.0 |
 |
|
Newbie
Joined: 08 May 2007
Posts: 6
|
Hi All,
I am trying to connect to Oracle 9.2.0.6 database from Message Broker 6.0 through the Database Node and get the following error when I run the flow in the debug mode.
Under the tree - DatabaseException - Insert - Text
"[Oracle][ODBC]Optional feature not implemented"
I have already executed the command mqsisetdbparms. The ODBC driver used is "Oracle in OraHome92". I am able to test the connection from the Windows ODBC Data Source Administrator, but from the broker it is not working. The control does not even go upto the ESQL, the moment it goes to the Database Node it throws exception.
The ESQL Code is
SET EMPNO = THE(SELECT ITEM S.EMPNO FROM Database.TESTDSN as S WHERE S.EMPNO ='7369');
Please let me know if Message Broker 6.0 supports ODBC connection to Oracle 9.2.0.6, Is the driver being used correct or some other driver is available, OR should we go for the Adapter.
Thanks in advance,
Afzal |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue May 08, 2007 6:29 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It is the wrong Oracle ODBC driver - you need to use the one that comes with broker. This is labelled as "Merant" or "Data Direct".
You also need, in that driver, to check "EnableDescribeSQLParams".
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| afzal |
| Posted: Tue May 08, 2007 7:04 am Post subject: |
|
|
Newbie
Joined: 08 May 2007
Posts: 6
|
| Thanks for the information, But I do get the userid and password error, whereelse can I set it apart from mqsisetdbparms. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 08, 2007 8:01 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
...
Once you use the right driver, then mqsisetdbparms should work.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| afzal |
| Posted: Tue May 08, 2007 8:13 pm Post subject: |
|
|
Newbie
Joined: 08 May 2007
Posts: 6
|
Thank you very much, it works fine now. I just restarted the system and it started working fine now. I am using the driver "MQSeries DataDirect Technologies 5.0 32-BIT Oracle".
Thanks |
|
| Back to top |
|
|
| afzal |
| Posted: Tue May 08, 2007 9:41 pm Post subject: |
|
|
Newbie
Joined: 08 May 2007
Posts: 6
|
Hi All,
It works fine from the system where Message Broker Ver 6.0 and Oracle Server 9.2.0.6 is installed. I am able to query as well as insert records into the Oracle Table.
But when I deploy the Message Flow into another Message Broker system, from where I am connecting to the Oracle Server 9.2.0.6 using the Oracle Client 9.2.0.6, only query statement works and it fails when I try to insert the record and gives the following error.
DatabaseException->Insert->Text=[Microsoft][ODBC Driver Manager]
Driver does not support this function.
Could someone please help me.
Thanks in advance,
Afzal |
|
| Back to top |
|
|
| Monk |
| Posted: Tue May 08, 2007 10:17 pm Post subject: |
|
|
Master
Joined: 21 Apr 2007
Posts: 282
|
What Driver are you using for the Oracle client?
_________________
Thimk |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed May 09, 2007 1:44 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Monk wrote: |
| What Driver are you using for the Oracle client? |
Yes, this is the thing.
EVERY ODBC connection to Oracle that Broker will use must be using the Data Direct driver.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| JohnSmith |
| Posted: Fri Apr 23, 2010 5:02 am Post subject: |
|
|
Voyager
Joined: 17 Mar 2010
Posts: 86
|
afzal wrote:
| Quote: |
Thank you very much, it works fine now. I just restarted the system and it started working fine now. I am using the driver "MQSeries DataDirect Technologies 5.0 32-BIT Oracle".
|
I am also trying to establish a connection to Oracle database located on another server, do we need to use the driver MQSeries DataDirect Technologies 5.0 32-BIT Oracle". I am quite confused regarding the driver to be used, there are 2 drivers are visible in ODBC Data Source Administrator one is Oracle in OraClient and another is MQSeries DataDirect Technologies 5.0 32-BIT Oracle". . Can I use the 1st or I need to use the latter one. I couln't find the right IBM documentation regarding this. If anyone can point me towards it then it would be very helpful. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Apr 23, 2010 7:12 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| JohnSmith wrote: |
I am also trying to establish a connection to Oracle database located on another server, do we need to use the driver MQSeries DataDirect Technologies 5.0 32-BIT Oracle". I am quite confused regarding the driver to be used, there are 2 drivers are visible in ODBC Data Source Administrator one is Oracle in OraClient and another is MQSeries DataDirect Technologies 5.0 32-BIT Oracle". . Can I use the 1st or I need to use the latter one. I couln't find the right IBM documentation regarding this. If anyone can point me towards it then it would be very helpful. |
If you are using the broker, the broker MUST use the MQSeries DataDirect driver or you may get unpredictable results. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
