Hi
Is there any way to submit a report based on free hand sql to the Broadcast Agent. When I do this I get a connection error.
Thanks
Will
William Sutton (BOB member since 2004-06-09)
Hi
Is there any way to submit a report based on free hand sql to the Broadcast Agent. When I do this I get a connection error.
Thanks
Will
William Sutton (BOB member since 2004-06-09)
Yes u can schedule free hand sql report to Broadcast Agent.
What error u getting. Please give exact error message.
Click on Details button on “DA005” error
JaiGupta (BOB member since 2002-09-12)
Hi
It’s a connection error. The message is Connection or SQL error (DA0005) (ORA-12154 …
William Sutton (BOB member since 2004-06-09)
Ok…here is the full error
ORA-12154 TNS:Could not resolve
service name.
Which means that the connection is pointing to a database instance which does have any entry in the Tnsnames.ora file on BCA server.
Solution :
Create the tnsnames entry in the tnsnames.ora file on BCA server for the dataase instance u r using in the connection.
This should fix ur problem
JaiGupta (BOB member since 2002-09-12)
Thanks, I’ll do that.
William Sutton (BOB member since 2004-06-09)