| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ODBC Connection from To Oracle |
« View previous topic :: View next topic » |
| Author |
Message
|
| CHAK DE |
 Posted: Wed Oct 10, 2007 2:49 am Post subject: ODBC Connection from To Oracle |
 |
|
Novice
Joined: 27 Sep 2007
Posts: 10
|
I want to establish an ODBC connection to oracle database on a Linux server from another linux server which hosts the broker.I have configured the odbc.ini file as below:
[OODDB]
Driver=/opt/ibm/mqsi/6.0/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=
WorkArounds=536870912
ProcedureRetResults=1
where OODDB is the datasource name.
I am not sure about the "ServerName" parameter above.
As per the documentation in infocenter,it is mentioned that :
"If you are using Oracle, specify the "Service Name" that resolves to a "Connect Descriptor", for example through a mapping in the TSNAMES.ORA file."
If this is the fact,then there is no tsnames.ora file on the broker's server.I gave the IP:port in ServerName parameter but it did not work.
Please suggest what values to give in ServerName parameter in odbc.ini file. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Oct 10, 2007 3:19 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Ask your Oracle administrator.
You need the Oracle client installed on the machine.
You also need to copy a tnsnames.ora file from another machine - that has a valid one - or the Oracle administrator needs to create one for you.
And then the Oracle administrator will tell you what to put in the ServerName field.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| CHAK DE |
| Posted: Wed Oct 10, 2007 4:54 am Post subject: ODBC connection to oracle |
|
|
Novice
Joined: 27 Sep 2007
Posts: 10
|
Is it not possible without installing the oracle client on broker's server?I mean can we add some more parameters (like hostname,ip and portnumber) in the stanza shown for oracle database in odbc.ini file?
Please suggest..... |
|
| Back to top |
|
|
| PieterV |
| Posted: Wed Oct 10, 2007 4:58 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
the servername is the name of the oracle server that you find in tnsnames.ora on the server of where the broker runs.
if you want to use the ora db within a message flow you also need to run the command mqsi_setdbparms, this will allow you the set a userid/pass to connect to "OODDB".
if not already done you should also run mqsi_setupdatbase.
To answer your second question, no it is not possible without installing an oracle client. You need to have an oracle client, and probably also need to set all variables for the oracle client in your user profile (like ORACLE_HOME etc) |
|
| 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
|
|
|
|
