13 Replies Latest reply: Mar 19, 2014 11:56 AM by Emmanuelle Bustos RSS

    Reload from Oracle; Server TNS failure but reload ok in desktop

    Dominic Ayling

      Hi All

      I have a document that links to Oracle through ODBC on our QV10 64bit Server. I have ODAC installed and configured and working well.

      If I open my document in desktop edition on the server the document reloads perfectly, however when I go into QMC and click the reload now button it fails, in the log I get this error:

      Error: SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

      I have tried to use OLEDB but have had problems when I try to make SQL calls to oracle to alter variables in a package, it doesn't set the variables properly.

      Any advice very welcome, Many thanks