sql server reporting services: I have SQL Server 2005 Enterprise edition setup. I am creating reports with
oracle as the data source. I can make the connection in report designer and
preview the reports with no error. And also deploy them to the report server.
But when I try to view them through report manager I get an error
'A processing error has occurred. ORA-12154 TNS:could not resolve the
connect identifier specified '

Any suggestions?

Thanks!

If you're developing reports on a workstation and they look good
locally, but error when you deploy, make sure the Oracle client on the
SSRS box is pointing to the correct Oracle Home directory. Best way to
do that is with the Oracle Network Config tool.

I've got mine setup to use the Oracle Supplied .Net 2.0 Connector and I
have to say that it is a much better connection than either OLE DB
Connector. Of course, you still need to setup TNS names correctly.


--
Garth H
webdev511@spamcop.net
Microsoft Certified Professional