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
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
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
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