Error reporting against Oracle 10g

I've got RS SP2 reporting against an Oracle 10g database. The reports will
run fine for a while, and then for some reason they will error out with the
error:
ORA-12154: TNS:could not resolve the connect identifier specified
If I restart the World Wide Web Publishing Service the reports will again
run fine for a while, and then the error out again.
Has anyone seen a similar issue?*Think* I found it.
The yahoo running their network had the server looking for itself (ala dns)
at an unresolvable external IP. Some wierd / inconsistent things were
happening tyring to access the server by name when on the server.
One entry to the hosts file, and we'll see if it does the trick.
"Jack" <anonymous@.microsoft.com> wrote in message
news:uIHh3OU5FHA.4076@.tk2msftngp13.phx.gbl...
> I've got RS SP2 reporting against an Oracle 10g database. The reports
> will run fine for a while, and then for some reason they will error out
> with the error:
> ORA-12154: TNS:could not resolve the connect identifier specified
> If I restart the World Wide Web Publishing Service the reports will again
> run fine for a while, and then the error out again.
> Has anyone seen a similar issue?
>sql