Author |
Message
|
wbiman |
Posted: Thu Mar 31, 2005 1:12 pm Post subject: Oracle Driver detail using ESQL |
|
|
Voyager
Joined: 13 Jul 2004 Posts: 84
|
Hi,
I am just wondering if anyone knows how to get database driver details using ESQL.in MQSI 2.1... I am trying to test program to confirm we are using right oracle drivers.
Thanks for help
Regards |
|
Back to top |
|
 |
Michael Dag |
Posted: Thu Mar 31, 2005 1:29 pm Post subject: Re: Oracle Driver detail using ESQL |
|
|
 Jedi Knight
Joined: 13 Jun 2002 Posts: 2607 Location: The Netherlands (Amsterdam)
|
wbiman wrote: |
I am just wondering if anyone knows how to get database driver details using ESQL.in MQSI 2.1... I am trying to test program to confirm we are using right oracle drivers.
|
What do you mean "using right oracle" drivers?
they work or they don't  _________________ Michael
MQSystems Facebook page |
|
Back to top |
|
 |
wbiman |
Posted: Thu Mar 31, 2005 1:33 pm Post subject: help |
|
|
Voyager
Joined: 13 Jul 2004 Posts: 84
|
Yes, What drivers we are using.....I am just wondering if there's any environment variable ...in ESQL ....i can use at run time to know whats the Oracle client driver version?
Thanks |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Mar 31, 2005 5:40 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
No.
There is no way to do this in ESQL.
Have you considered asking your Oracle administrator? _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
fschofer |
Posted: Thu Mar 31, 2005 10:54 pm Post subject: |
|
|
 Knight
Joined: 02 Jul 2001 Posts: 524 Location: Mainz, Germany
|
Hi,
take a look at the oracle db Driver setting in your .odbc.ini
Run the command
ldd <driverxyz.so>
to find out which libclntsh.so you are using,
Then run the command
strings </xyz/>libclntsh.so | grep Version
to find out the version of the oracle client.
Greetings
Frank |
|
Back to top |
|
 |
|