Remote db connections possible with DCOracle2?
dave at pythonapocrypha.com
Thu Jul 3 00:25:13 CEST 2003
On Wednesday 02 July 2003 03:18 pm, Dave Brueck wrote:
> On Wednesday 02 July 2003 02:13 pm, Skip Montanaro wrote:
> > Connections to remote Oracle databases doesn't seem possible with
> > DCOracle2. I have no problem making remote connections using Perl's
> > DBI::Oracle package, so I know it's possible in theory. Is this
> > capability available in DCOracle2 but just not documented perhaps?
> Actually, I've never used a _local_ database with DCOracle2, so it's very
> possible but, IMO, very underdocumented too. :)
> Use this style of connection string (all one line if it wraps):
> (changing the values of user, password, 10.20.30.40, and dbsid of course).
Replying to myself here because I forgot to mention that the benefit of the
hideous connection string is that it requires no modification to your
TNSNAMES.ORA file (I believe the normal way of connecting to a remote DB is
to specify a certain name that you've configured in TNSNAMES.ORA).
The above is particularly important if you don't have a true Oracle client
installation (IIRC last year I posted a list of just the files you need to
make DCOracle2 work without doing a full Oracle client install - on Linux, at
least for me, the Oracle client install was massive, scary, and flaky).
More information about the Python-list