Free Hand SQL via Broadcast Agent

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)