Remote db connections possible with DCOracle2?

[Dave Brueck]

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):
>
> user/password@(description=(address=(host=10.20.30.40)(protocol=tcp)(port=1
>521))(connect_data=(sid=dbsid)))
>
> (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).

-Dave