Re: [cx-oracle-users] connect from a remote box

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

Klaus Boehm wrote:
> i try to connect to a oracle db.
> this db runs on another server.
> now i have problem with the connect string.
>
> connect([user, password, dsn, mode, handle, pool, threaded, twophase])
>
> how looks the dsn if i try to connect from a remote box?

If you know how to connect with sql*plus, you've already typed a
connection string like "<user>/<password>@<dsn>". So it's easy.


Else, you must know the name of the server, and the name of the database
on the server (the service name).

If you installed the Oracle client version 10g, the dsn is simply
dsn = "<server>/<service>"

With a 8i or 9i Oracle client, it's more complicated:
dsn = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST
=<server>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<service>)))"
(All in one string, you may add spaces if you want)
You may want to have a (short) alias for this long string, in this case
you must edit the tnsnames.ora file. But this is another story.

Hope this helps,

--
Amaury Forgeot d'Arc