I can successful connect to my Oracle database using ODBC (SYSTEM DSN), I can access it using SQL*Plus and entering the host (from TNSNames) and username /password and also can see the data when loggin into SQL developer.
I've got Visio 2010 and trying to create a database diagram and connect it to extrnal data (my oracle database)
I go the data tab -> Link Data to shapes
Try and Connect to ODBC DSN and select the one i've created and get the following error:
ORA-12154:TNS:could not resolve service name
I've checked the environment variables and that the PATH and ORACLE_HOME Look correct but I'm stumped as to why this works everywhere apart from in Visio 2010 professional?