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

[#1]

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

Dominic

[RedSky001]

sdgt12 I had the same problem, it was the good old reboot which did the trick, thanks for that.

[Bill_Britt]

This is a older document but my understanding it still works. You just use the current release from Oracle.

Bill

[#4]

Hey Dana,

I am facing the same issues could you please help me on this or can you share the doc on vkk0417@gmail.com

Regards,

Kiran

[Emmanuelle__Bustos]

Hi Kiran

Did you try what Stephen suggests?:

"I just wanted to share that I have QV9SR3, on the server.  Installed the Oracle 10.2 client.  QV reloads fine, but from the scheduler, or Management Console it did not.  However after a reboot of the server, as suggested elsewhere, this did the trick.  So no need to install an oracle database, or a bug.  Just a reboot after installing the Oracle 10 client.  Then the ODBC/OLE Oracle connection on non interactive QV reload will work."