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?