RE: Find client version

We're in the progress of migrating from 8i to 10g, and are=20 planning on setting up some of our developers to using the 10g client under ColdFusion. However, since our production database is still 8i, we can't completely ditch 8i until production moves to 10g. The 10g client does will not connect to an 8.1.6 database. In the interim, our developers will be mostly trying to use the 10g client, but at times may have to revert back to 8i when they need to debug things that are on the 8i machines. So what we want is to get put in the the ColdFusion cold a code snippet that detects what client is=20 being run, and give a friendly reminder to the developer that he/she is running with 8i.

(My preference truthfully is to put 10g in a completely separate machine so that we don't end up with both 8 and=20 10 clients on the same machine, but we're kind of strapped for hardware, and putting 8 and 10 on the same machine and repointing the search path was the compromise solution.)

...Rudy

-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]=20 Sent: Friday, November 12, 2004 7:50 AM
To: Rudy Zung; oracle-l_at_freelists.org
Subject: RE: Find client version

Rudy,

Why do you need to know what version your client is using? Wouldn't it = be
easier just to program for the lowest common version in your = environment?
And, just curious, what capability is in the 10g version that is not in = the
8i version is giving you problems?

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Rudy Zung [mailto:Rudy.Zung_at_efi.com]=20 Sent: Thursday, November 11, 2004 10:36 AM To: oracle-l_at_freelists.org
Subject: RE: Find client version

Not quite what I was looking for. Our developers are going to have a need for both 8i and 10g clients on=3D20 their machines; they'll be developing under ColdFusion. After a connection has been made to an Oracle server, we need the session itself to find out what version of Oracle client got fired up to make the connection.

But, thanks for your answer anyway.

...Rudy

-----Original Message-----
From: Jeremiah Wilton [mailto:jwilton_at_speakeasy.net]=3D20 Sent: Wednesday, November 10, 2004 6:09 PM To: Rudy Zung
Cc: oracle-l_at_freelists.org
Subject: Re: Find client version

On Wed, 10 Nov 2004, Rudy Zung wrote:

> Is there any way to programatically determine what=3D3D20 version of=20
> client that I'm using?

You can find the client version in the client shared library:

strings $ORACLE_HOME/lib/libclntsh.so | grep ^Version

Not sure if this helps you. I suspect there is an OCI call you can make = to
get this, but I didn't take the time to search around for it.

--
Jeremiah Wilton
Independent Oracle Professional
Oracle Certified Master
Disaster Recovery - Seminars - Technical Interviews
http://www.speakeasy.net/~jwilton
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l