| Author |
Message
|
| mahek |
 Posted: Thu Apr 12, 2007 6:14 am Post subject: accessing oracle from compute node |
 |
|
Voyager
Joined: 10 Sep 2004
Posts: 87
|
Hi all,
I am using mqsi 2.1 and from the compute node i want to access a oracle database which is on a diferent system.
can any one help me how to configure this.
Thanks in advance |
|
| Back to top |
|
 |
| WMBNJ |
| Posted: Thu Apr 12, 2007 6:20 am Post subject: |
|
|
Newbie
Joined: 06 Apr 2007
Posts: 3
|
| Did you create a odbc connection to the database, haveyou installed Oracle client on your machine? What have you done? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Apr 12, 2007 6:20 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You're running obsolete software. Not only is it obsolete, it's unsupported.
You are taking a signfiicant business risk by using this software in production, and should be doing no new development in this version.
The steps to access a remote Oracle database from Broker are the same as the steps to access any database from Broker.
1) Create an functioning ODBC datasource to that database
2) Use the name of that datasource in your message flows.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jeevan |
| Posted: Thu Apr 12, 2007 6:25 am Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
| jefflowrey wrote: |
You're running obsolete software. Not only is it obsolete, it's unsupported.
You are taking a signfiicant business risk by using this software in production, and should be doing no new development in this version.
The steps to access a remote Oracle database from Broker are the same as the steps to access any database from Broker.
1) Create an functioning ODBC datasource to that database
2) Use the name of that datasource in your message flows. |
Jeff,
If the platform is not windows, for example, if your broker resides on other then Windows where you can not create datasource ( i may be wrong), how can we do that? Is this the situation where we use database client?
Thanks |
|
| Back to top |
|
|
| mahek |
| Posted: Thu Apr 12, 2007 6:27 am Post subject: |
|
|
Voyager
Joined: 10 Sep 2004
Posts: 87
|
Thanks for the replies,
we are migrating to 6.0 in july till that time we have to deal will 2.1.
i have done the the steps that you all have mentioned but i get an error
Database error: SQL State '08001'; Native Error Code '12154'; Error Text '[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service name'.
thanks in advance |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Apr 12, 2007 6:29 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
That's likely the wrong driver to be using for accessing Oracle. I believe you need to use the ODBC driver that comes with the product - the Merant/DataDirect driver.
But I don't know if that's true for 2.1.
Also, the specific message you see is an oracle client configuration problem.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
