Posted: Tue Mar 16, 2004 3:21 am Post subject: Connecting to oracle database in AIX
Voyager
Joined: 05 Aug 2002 Posts: 79 Location: US
Hi,
I'm using a MQSI broker in AIX environment, Oracle database is also installed in the same machine.
What is the setting that I need to make in AIX (just like we create dsn in NT) to access the database in my compute node.
You need to make DSN entry in /var/mqsi/odbc/.odbc.ini file. You can refer to WMQI Admin guide for AIX to find how set the properties in .odbc.ini. Before perforimg this step, confirm with your DBA if TNS name for your database instance is define or not. You need TNS name when you configure DSN in .odbc.ini file _________________ IBM Certified Specialist MQSeries
IBM Certified Specialist - Websphere MQ Integrator
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