| Author |
Message
|
| Rahul999 |
 Posted: Thu Mar 11, 2010 3:14 am Post subject: [Oracle][ODBC]Optional feature not implemented |
 |
|
Centurion
Joined: 14 Mar 2007
Posts: 134
|
Hi,
I am trying to establish a connection to a ORACLE database from Message flows. To setup the database connection I have complted the following required steps.
1. Created a ODBC connection to that database.
2. Authorize the Message broker to connect to that database(Using mqsisetdbparms command.
3. Have specified the database name in the Compute node properties.
But, i am getting the error while I trying to access the database inside the Compute Node.
[Oracle][ODBC]Optional feature not implemented
Could anybody please help where I am missing.
Regards,
_________________
"For all your days be prepared, and meet them ever alike.
When you are the anvil, bear - when you are the hammer, strike."
- Edwin Markham |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Mar 11, 2010 3:18 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| You've done step 1 wrong. |
|
| Back to top |
|
|
| Rahul999 |
| Posted: Thu Mar 11, 2010 4:38 pm Post subject: |
|
|
Centurion
Joined: 14 Mar 2007
Posts: 134
|
| Quote: |
You've done step 1 wrong.
|
Hi Jeff,
Could you please tell me which step is that?
Regards,
_________________
"For all your days be prepared, and meet them ever alike.
When you are the anvil, bear - when you are the hammer, strike."
- Edwin Markham |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Mar 11, 2010 4:46 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Rahul999 wrote: |
| Quote: |
You've done step 1 wrong.
|
Hi Jeff,
Could you please tell me which step is that?
Regards, |
I'm guessing the one with a 1) next to it. 
I suspect my worthy associate in turn suspects your ODBC is using a driver which doesn't implement one or more features your flow is using.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Rahul999 |
| Posted: Thu Mar 11, 2010 9:47 pm Post subject: |
|
|
Centurion
Joined: 14 Mar 2007
Posts: 134
|
| Quote: |
| I suspect my worthy associate in turn suspects your ODBC is using a driver which doesn't implement one or more features your flow is using. |
Vitor, I am using oracle in oraclient10g_home1 driver driver. And I have set up and ODBC Connection to the same.
Regards,
_________________
"For all your days be prepared, and meet them ever alike.
When you are the anvil, bear - when you are the hammer, strike."
- Edwin Markham |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Mar 11, 2010 9:52 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Then you did not follow the manual. You should have the oracle client present and referenced but the ODBC.ini should not point to the oracle driver...
Read up in the manuals... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Rahul999 |
| Posted: Thu Mar 11, 2010 10:34 pm Post subject: |
|
|
Centurion
Joined: 14 Mar 2007
Posts: 134
|
Hi
| Quote: |
Then you did not follow the manual. You should have the oracle client present and referenced but the ODBC.ini should not point to the oracle driver...
|
I am setting up the ODBC connection in the Windows and not using any ODBC.ini file.
_________________
"For all your days be prepared, and meet them ever alike.
When you are the anvil, bear - when you are the hammer, strike."
- Edwin Markham |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Mar 11, 2010 11:42 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Rahul999 wrote: |
I am setting up the ODBC connection in the Windows and not using any ODBC.ini file. |
There is an ODBC.ini under the hood even on Windows. You just don't see it as the wizard does all the stuff for you. I've seen questions when deleting a source if you'd like it to be deleted from odbc.ini.
In your case, I think you may have selected the wrong driver from the list (my guess)
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Mar 12, 2010 12:38 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
You MUST use the ODBC driver that comes with WMB
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
|
|
