Which Oracle Version?

  • Thread starter Thread starter Steve Graddy
  • Start date Start date
S

Steve Graddy

Hi folks,
I am writing an application that uses the Microsoft Oracle Client. I am
aware that this provider
requires the Oracle 8.1.7 client or newer to be installed on the users
machine. I have searched for
hours on the internet and Oracles site as to how to determine if the Oracle
Client is installed and if
so what version is installed programmatically with C# code. Is there someone
out there that has done
this and if so could you enlighten me with a code sample. Thanks...

Steve Graddy MCP, MCAD.Net
 
See this thread if it helps:
http://www.google.com/groups?hl=en&...ient+version&hl=en&lr=&ie=UTF-8&start=10&sa=N
(it has been a while I've used Oracle)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Steve Graddy said:
Hi folks,
I am writing an application that uses the Microsoft Oracle Client. I am
aware that this provider
requires the Oracle 8.1.7 client or newer to be installed on the users
machine. I have searched for
hours on the internet and Oracles site as to how to determine if the
Oracle
Client is installed and if
so what version is installed programmatically with C# code.
Click to expand...
..
Is there someone
 
Steve Graddy said:
Hi folks,
I am writing an application that uses the Microsoft Oracle Client. I am
aware that this provider
requires the Oracle 8.1.7 client or newer to be installed on the users
machine. I have searched for
hours on the internet and Oracles site as to how to determine if the
Oracle
Client is installed and if
so what version is installed programmatically with C# code. Is there
someone
out there that has done
this and if so could you enlighten me with a code sample. Thanks...
Click to expand...

Look at the FileVersion of OCI.dll.

Example of using

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=##bdB2kQBHA.1444@tkmsftngp03

Or with the MS OracleClient, you should be able to use Oracle Instant
Client.

http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html

It's 60 megs, or so, but you can just copy it to your bin folder and and run
it.

David
 
I don't think the Oracle Client is distributed by Microsoft. Even if it
was, you'd still need to apply patchsets from the Oracle site.
 
Hi Steve,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to check for the current
Oracle client version on the client machine. If there is any
misunderstanding, please feel free to let me know.

Based on all the replies above, I think Miha's method is the best one. We
can check the registry key to see the version. This is simply and reliable.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Hi Steve,

I'd like to know if this issue has been resolved yet. Is there anything
that I can help. I'm still monitoring on it. If you have any questions,
please feel free to post them in the community.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Hi Kevin,
I have not had time to try this but Miha Markic suggested thread
seems to be the only one that might work. That is what I am needing to
do. As some of the folks replying did not understand my needs, I still
appreciated their input. It looks as if checking the registry for the
Oracle Home entry and then reading the "nt.rgs" file for the info may be
the only way to find out the installed Oracle client on my users
machine. Thanks for keeping an eye on this for me. You guys at MSFT are
the greatest...

Steve Graddy MCP, MCAD.Net
Orgbrat Consulting
 
Hi Steve,

Thanks for sharing your experience with all the people here. If you have
any questions, please feel free to post them in the community.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top