Remote db connections possible with DCOracle2?

[Andy Todd]

Skip Montanaro wrote:
>     Dave> Use this style of connection string (all one line if it wraps):
> 
>     Dave> user/password@(description=(address=(host=10.20.30.40)(protocol=tcp)(port=1521))(connect_data=(sid=dbsid)))
> 
> Thanks.  The example or two I saw indicated something like
> 
>     user/password at dbname
> 
> where I presume "dbname" is looked up in tnsnames.ora.
> 
> Skip
> 

The 'correct' way to connect to an Oracle database is, as you say, 
through a service name that you have configured and which is stored in 
the local tnsnames.ora file.

In later versions of Oracle (8.1 and above) it is strongly recommended 
that you configure your connectivity through the supplied tools (Net8 
Assistant or Oracle Net Manager).

Editing tnsnames.ora files by hand is somewhat frowned upon. Having said 
that the format and syntax hasn't changed (much) since the days of 
SQL*Net so if you know what you are doing it isn't too scary.

Practically, if you can connect to a database from SQL*Plus then 
DCOracle2 won't have a problem either.

Regards,
Andy
-- 
--------------------------------------------------------------------------------
 From the desk of Andrew J Todd esq - http://www.halfcooked.com/