How to connect oracle database with python pypyodbc

Question

I am trying to connect an oracle database from my python code using pypyodbc:

conn_string = "driver={Oracle in OraClient11g_home1}; server='example.oneco.com:1521'; database='tabto'; uid='myuid'; pwd='mypwd'"
conn = pypyodbc.connect(conn_string)

I got error message:

Error: (u'HY000', u'[HY000] [Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error\n')

Following is the connection string found in my tnsnames.ora file. Please tell me what is the right way to use pypyodbc.

tabto, tabto.world, tabto.oracleoutsourcing.com, tabto.oneco.com =
  (DESCRIPTION =
    (ADDRESS = 
      (PROTOCOL = TCP)
      (HOST = example.oneco.com)
      (PORT = 1521)
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = tabto_dcu)
    )
  )

The key is to link python code to tnsname.ora by define dbq parameter. So change the code to the following worked. conn_string = "driver={Oracle in OraClient11g_home1}; dbq='tabto'; uid='myuid'; pwd='mypwd'" conn = pypyodbc.connect(conn_string) — ju.
– ju., Commented Jan 5, 2017 at 16:36

ju. · Accepted Answer · 2017-01-06 02:25:22Z

3

The key is link python code to tnsname.ora by defining dbq parameter. So change the code to the following worked.

conn_string = "driver={Oracle in OraClient11g_home1}; dbq='tabto'; uid='myuid'; pwd='mypwd'"
conn = pypyodbc.connect(conn_string)

edited Jan 6, 2017 at 2:25

answered Jan 5, 2017 at 16:34

ju.

1,0962 gold badges14 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yi Zong Kuang Over a year ago

I just want to clarify for future references, as I got confused about this. But the parameter for dbq can be any of the tns names specified. So dbq='tabto.oneco.com' or dbq='tabto.world' would work also.

Diogo Sousa · Accepted Answer · 2017-01-05 00:40:33Z

0

conn = pyodbc.connect(r'DRIVER={SQL Server Native Client 11.0};SERVER=example.oneco.com:1521;DATABASE=tabto;UID=youruid;PWD=password')

try it without quotes(') of your code in the middle...

check too pyodbc wiki: https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Windows

answered Jan 5, 2017 at 0:40

Diogo Sousa

172 bronze badges

Collectives™ on Stack Overflow

How to connect oracle database with python pypyodbc

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related