Connect to oracle db instance using service name (TNS) - cx_Oracle. How?

bluef1shorcl

How can I connect to remote oracle instance using service_name defined in TNSNAMES,ORA defined in local and using cx_Oracle 6.0 ? any code samples available?

I have tried the conn_str = u'username/[email protected]_name'  , got this error -

cx_Oracle.DatabaseError: DPI-1041: invalid character set id 178

Anthony Tuininga-Oracle

Perhaps try this?

conn = cx_Oracle.connect(conn_str, encoding = "UTF-8", nencoding = "UTF-8")

The error you are getting suggests that you have some information missing from your NLS libraries which the above code will bypass.

Anthony Tuininga-Oracle

Perhaps try this?

conn = cx_Oracle.connect(conn_str, encoding = "UTF-8", nencoding = "UTF-8")

The error you are getting suggests that you have some information missing from your NLS libraries which the above code will bypass.

bluef1shorcl

Thanks a ton!

Anthony Tuininga-Oracle

You're welcome. Glad to be of help!