Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sdgt12 I had the same problem, it was the good old reboot which did the trick, thanks for that.
This is a older document but my understanding it still works. You just use the current release from Oracle.
Bill
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
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."