| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Datasource for oracle |
« View previous topic :: View next topic » |
| Author |
Message
|
| Fuzzy_mq |
 Posted: Wed Feb 02, 2005 6:57 am Post subject: Datasource for oracle |
 |
|
Apprentice
Joined: 27 May 2004
Posts: 31
Location: US
|
Folks,
I have been given requirement to access oracle 9i database thru ESQL. I need to select data from DB. I have oracle client installed on my machine and I know the database schema.
Now in the DatabaseNode I need to enter datasource and table name. I have the table name but what should be the format of datasource?
Also is there anything else I need to configure to access the DB?
Regards,
Scht |
|
| Back to top |
|
 |
| JT |
| Posted: Wed Feb 02, 2005 7:31 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
The value for the DataSource parameter on the Database node can be choosen from those DataSources that are defined in your .odbc.ini file.
| Quote: |
| Also is there anything else I need to configure to access the DB |
- assign a database id/password for the DataSource via the mqsisetdbparms command
- ensure tnsnames.ora has been configured properly
- setup the proper database links for the Oracle platform using the mqsi_setupdatabase command
- define the required environment variables (i.e. LD_LIBRARY_PATH, ORACLE_HOME, ODBCINI, etc...)
- establish a symbolic link, if XA coordination is a requirement
- use the 32-bit Oracle client (\lib32)
- ensure successful database connectivity by first, using the sqlplus tool, supplied with the Oracle client
|
|
| Back to top |
|
|
| Fuzzy_mq |
| Posted: Wed Feb 02, 2005 7:43 am Post subject: |
|
|
Apprentice
Joined: 27 May 2004
Posts: 31
Location: US
|
Thanks JT for the reply.
Database connectivity is fine. I am able to connect using SQLPlus/Toad. I will perform rest of the points and revert if I face issues.
Just FYI, I am using WMQI 2.1.
Regards,
Scht |
|
| 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
|
|
|
|
