Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm trying to connect to an Oracle database from a client machine and I'm getting an ORA-12560: TNS:protocol adapter error from a python script using pypyodbc as my ODBC library.

I have researched this as thoroughly as possible but its the strangest thing. I have verified my tnsnames.ora file and environment variables are all setup properly. I'm able to make a successful test connection through the ODBC manager on Windows XP (which is the machine I'm attempting to connect from). The driver is the Oracle Client 10.2.

Doing a tnsping MYORADB is successful (using the same TNSNAMES file). I have tested the exact same setup on a colleagues machine and it was successful using the same Python installation and ODBC library.

Ruling out issues with the client driver, tnsnames.ora, environment variables, what other issues can cause a TNS:protocol adapter error?

share|improve this question
Is MYORADB the TNS name you're trying to resolve? – Sathya Apr 5 at 13:47

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.