Re: [cx-oracle-users] cx_Oracle.makedsn not using remote host

[Anthony T. <ant...@gm...>]

Hmm, I'm not sure exactly what you think the problem is. From your
demo below the dsn produced by your call to makedsn() looks just fine.
Can you indicate what you were expecting to happen?

On 11/5/05, Paul Watson <pw...@re...> wrote:
> When I use cx_Oracle.makedsn for a remote connection, the host is replace=
d with my own local hostname and not that of the system running the Oracle =
engine.  I also tried "@TRAIN" for the SID with no effect.  Am I doing some=
thing incorrectly.  Please advise.
>
> C:\src\python\db\cx_Oracle>python
> Python 2.4.2 (#67, Sep 28 2005, 12:41:11) [MSC v.1310 32 bit (Intel)] on =
win32
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import cx_Oracle
> >>> cx_Oracle.version
> 'HEAD'
> >>> cx_Oracle.buildtime
> 'January 26, 2005 14:37:48'
> >>> dsn =3D cx_Oracle.makedsn("pwatson", 1521, "TRAIN")
> >>> dsn
> '(DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dpwatso=
n)(PORT=3D1521)))(CONNECT_DATA=3D(SID=3DTRAIN)))'
> >>> ^Z
>
>
> C:\src\python\db\cx_Oracle>cat \oracle\ora81\network\admin\tnsnames.ora
> # TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\=
tnsnames.ora
> # Generated by Oracle configuration tools.
>
> TRAIN.ADOMAIN.COM =3D
>   (DESCRIPTION =3D
>     (ADDRESS_LIST =3D
>       (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 172.16.0.80)(PORT =3D 1521=
))
>     )
>     (CONNECT_DATA =3D
>       (SERVICE_NAME =3D train)
>     )
>   )
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Downl=
oad
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>