cx-oracle-users

[cx-oracle-users] Lightweight/built-in Oracle client

[Aaron H. <ne...@gm...>]

Hello All,

Using cx_Oracle, I'm trying to establish a connection to a remote database.
I tried to deploy my tool on a terminal without any kind of Oracle client
software. While I run Oracle client software on my machine, I'd prefer to
not have to deploy Oracle client on any terminal wishing to use this tool.
As I read through the mailing list, a similar question was posed, but I
don't know if a client solution was ever included into cx_Oracle

Re:
http://sourceforge.net/mailarchive/forum.php?thread_id=8719369&forum_id=34464:

From: Anthony Tuininga <anthony.tuininga@gm...>
 Re: Minimum client requirements for
cx_Oracle<http://sourceforge.net/mailarchive/message.php?msg_id=13558142>
2005-10-21 06:57

  I can definitely add something like that to the setup.py that comes
 with cx_Oracle. If anyone on this list has done the same thing with
  Windows and Cygwin I'd like to know the changes needed for those
 platforms.


The other proposed solution included using the OIC. If cx_Oracle has no
alternative, I'll make use of this, but I just wanted to see if anyone had a
brighter idea. I am using a w32 environment, connecting to Oracle 9i DB

Thank you,
Aaron H.
-- 
Vi Veri Veniversum Vivus Vici

Re: [cx-oracle-users] Lightweight/built-in Oracle client

[Amaury F. d'A. <ama...@gm...>]

2006/9/23, Aaron Heinrich <ne...@gm...>:
> Hello All,
>
>  Using cx_Oracle, I'm trying to establish a connection to a remote database. I tried to deploy my tool on a terminal without any kind of Oracle client software. While I run Oracle client software on my machine, I'd prefer to not have to deploy Oracle client on any terminal wishing to use this tool. As I read through the mailing list, a similar question was posed, but I don't know if a client solution was ever included into cx_Oracle
...
>
>  The other proposed solution included using the OIC. If cx_Oracle has no alternative, I'll make use of this, but I just wanted to see if anyone had a brighter idea. I am using a w32 environment, connecting to Oracle 9i DB
>

To my knowledge, any connection to an Oracle database requires one of
these three components :
- a regular Oracle client installation
- Oracle Instant Client
- the Oracle JDBC "Thin" driver. This one has no chance to work with cx_Oracle.

On Windows at least, it's very easy to use the Oracle Instant Client
with cx_Oracle: just copy the 3 needed Dlls in the same directory as
cx_Oracle.pyd ! And no need to change setup.py: the standard
distribution should work as is.

Hope this helps,

-- 
Amaury Forgeot d'Arc