Author |
Message
|
swann |
Posted: Thu Dec 15, 2011 7:37 am Post subject: ODBC file location |
|
|
Acolyte
Joined: 21 Jun 2011 Posts: 50
|
We have created a XX DNS file in order to connect to Oracle Db but now we would like to known the file location of this file.Does broker set up anything in such a way that all DNS defined will be present in one particular directory.Please help.......... |
|
Back to top |
|
 |
mqjeff |
Posted: Thu Dec 15, 2011 7:46 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
So you mean you have created a properly formatted Message Broker odbc.ini file?
And you're trying to figure out where Broker will look for it?
Broker will look for it at the location specified in the ODBCINI environment variable. |
|
Back to top |
|
 |
swann |
Posted: Thu Dec 15, 2011 8:02 am Post subject: |
|
|
Acolyte
Joined: 21 Jun 2011 Posts: 50
|
Is it mandatory to fill in the INSTALLDIR,TRCFill and TRACEDLL at mandatory stanza................Because here at var/mqsi/odbc.ini i see only the oracle DNS and oracle stanza are filled in .I dont see any of the mandatory stanza is filled in. |
|
Back to top |
|
 |
mqjeff |
Posted: Thu Dec 15, 2011 8:22 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
|
Back to top |
|
 |
bloomy |
Posted: Thu Dec 15, 2011 9:13 am Post subject: |
|
|
 Acolyte
Joined: 11 Feb 2009 Posts: 61 Location: Bloomington, IL USA
|
It is easier and recommended to use the odbc.ini sample file from the broker installation directory. You will have format for different databases there. |
|
Back to top |
|
 |
mqjeff |
Posted: Thu Dec 15, 2011 9:48 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
bloomy wrote: |
It is easier and recommended to use the odbc.ini sample file from the broker installation directory. You will have format for different databases there. |
I'm confused.
I think I said the same thing? |
|
Back to top |
|
 |
bloomy |
Posted: Thu Dec 15, 2011 12:29 pm Post subject: |
|
|
 Acolyte
Joined: 11 Feb 2009 Posts: 61 Location: Bloomington, IL USA
|
Quote: |
I think I said the same thing? |
I am not contradicting on what you said mqjeff, I was just trying to add to your statement about the location of the file you mentioned. I should have constructed my statement properly but was in hurry so submitted without checking it.
My intention was towards the original post and not your response.
Sorry for that! |
|
Back to top |
|
 |
|