Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question

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.