|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
Access Oracle v9.2 with WMQI 2.1 in AIX v5.2 with DB2 8.1.4 |
View previous topic :: View next topic |
Author |
Message
|
miguelanselmo |
Posted: Mon May 17, 2004 5:48 am Post subject: Access Oracle v9.2 with WMQI 2.1 in AIX v5.2 with DB2 8.1.4 |
|
|
Novice
Joined: 28 Oct 2003 Posts: 15
|
Hi,
I have to access an Oracle v9.2 database with WMQI v2.1 that is installed on AIX v5.2 with DB2 v8.1.4.
I have read that I can use an ODBC driver that came with WMQI (UKOR818).
My question is, do I have to install any other software (any tool that came with the Oracle software) to accomplish this connection and/or configuration I have to do in “odbc.ini” file.
Any help would appreciated. |
|
Back to top |
|
 |
JT |
Posted: Mon May 17, 2004 6:34 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT.
|
Quote: |
I can use an ODBC driver that came with WMQI (UKOR818) |
That's correct.
Quote: |
do I have to install any other software (any tool that came with the Oracle software) |
Just the Oracle client.
Quote: |
.....or configuration I have to do in “odbc.ini” file. |
- ensure tnsnames.ora has been configured properly
- issue the mqsi_setupdatabase command
- define the environment variables (i.e. LD_LIBRARY_PATH, ORACLE_HOME, ODBCINI, etc...)
- establish a symbolic link, if XA coordination is a requirement
Additionally, the minimum configuration must be WMQI v.2.1.5 and MQ v5.3.4 to access Oracle v9.2 databases from AIX v5.2. |
|
Back to top |
|
 |
miguelanselmo |
Posted: Mon May 17, 2004 7:18 am Post subject: |
|
|
Novice
Joined: 28 Oct 2003 Posts: 15
|
|
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
|
|
|
|