Re: Connecting to remote Oracle db via Python

2011-02-18 Thread Alexander Gattin
Hello, On Thu, Feb 17, 2011 at 02:40:22AM -0800, pstatham wrote: > I've installed the cx_Oracle module for Python > and I'm trying to connect to my remote Oracle > db. Can you tnsping your remote Oracle DB successfully? > >>> uid = "scott" > >>> pwd = "tiger" > >>> service = "10.5.1.12:1521:PR10

Re: Connecting to remote Oracle db via Python

2011-02-17 Thread Anurag Chourasia
t;> From: Anurag Chourasia [mailto:anurag.choura...@gmail.com] >> Sent: 17 February 2011 14:41 >> To: Paul Statham >> Cc: python-list@python.org >> Subject: Re: Connecting to remote Oracle db via Python >> >> Could you try by using a connecting string in t

Re: Connecting to remote Oracle db via Python

2011-02-17 Thread Anurag Chourasia
u, Feb 17, 2011 at 8:18 PM, Paul Statham wrote: > Doesn't seem to work > > -Original Message- > From: Anurag Chourasia [mailto:anurag.choura...@gmail.com] > Sent: 17 February 2011 14:41 > To: Paul Statham > Cc: python-list@python.org > Subject: Re: Connecting to r

Re: Connecting to remote Oracle db via Python

2011-02-17 Thread Anurag Chourasia
Could you try by using a connecting string in the standard format as below? Connection_String = 'scott/tiger@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.5.1.12(PORT=1521)))(CONNECT_DATA=(SID=PR10)))' db = cx_Oracle.connect(Connection_String) Regards, Anurag On Thu, Feb 17, 2011 a

Connecting to remote Oracle db via Python

2011-02-17 Thread pstatham
Hi Guys, I've installed the cx_Oracle module for Python and I'm trying to connect to my remote Oracle db. Like so (username, password and ip below aren't real don't worry) >>> uid = "scott" >>> pwd = "tiger" >>> service = "10.5.1.12:1521:PR10" >>> db = cx_Oracle.connect(uid + "/" + pwd + "@" + se