| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Generic method of accessing database |
« View previous topic :: View next topic » |
| Author |
Message
|
| psk |
 Posted: Fri Jun 21, 2002 6:03 am Post subject: Generic method of accessing database |
 |
|
Novice
Joined: 24 Apr 2002
Posts: 14
|
Hi,
I have 3 systems defined at my end DEV, QA, PROD. I use a compute node to access values from a oracle database. In the compute node , I have to define the ODBC connection name, say CCROUTE where CCROUTE maps to DEV database in development , and maps to QA database in QA and PROD database in production.
But my .odbc.ini file was identical in all 3 environments before this. But on adding the CCROUTE connection, it has become different in DEV, QA and PROD as the CCROUTE points to 3 different databases in 3 files..
Is there any way in which I can keep the file identical in all the 3 environments and yet make them point to different databases. Can I somehow say in ESQL that use the same database connection as that of the WMQI broker.
Thanks in advance for the help, |
|
| Back to top |
|
 |
| lichang |
| Posted: Fri Jun 21, 2002 7:34 am Post subject: |
|
|
Newbie
Joined: 28 Apr 2002
Posts: 5
|
| You can setup generic connectivity through the tnsname setting to link them with identical DB name. |
|
| Back to top |
|
|
| psk |
| Posted: Fri Jun 21, 2002 8:53 am Post subject: |
|
|
Novice
Joined: 24 Apr 2002
Posts: 14
|
Thanks for the reply but I didnt understand how to do that..
can you please explain in a little detail |
|
| 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
|
|
|
|
