Re: [cx-oracle-users] Supporting multiple Oracle Client versions on Win32

[<ama...@ub...>]

Hello,

> Hoping for a bit of advice and apologies up front if this is a dumb
> question (it may be).
>
> Have an executable Python app built with py2exe that uses cx_Oracle
> (currently one of the binary versions built for Oracle 8.x). Now in a
> situation where I need to support both the Oracle 8.x client and the
> 9.x client (some users have 8.x, others have 9.x).
>
> Is there a way I can do this at runtime i.e. detect the Oracle client
> version and load the correct cx_Oracle version? Guess that implies
> having multiple versions of the Oracle client and cx_Oracle installed
> on the PC where I build the app with py2exe. What I'm hoping to
> provide a single executable that will work for all Oracle client
> versions.

The cx_Oracle built for Oracle 8 should work as well on a 9.x client.
There is nothing to do except to ensure that OCI.DLL can be located
through the PATH environment variable.

I guess this is only true for Windows platforms...

--
Amaury Forgeot d'Arc
Ubix Development
www.ubitrade.com