Re: Oracle connection problems (MS SQL Reporting Services)

Thanks for all the help! I have it working now.

I had to add the TNSNAMES and SQL.ORA files to the SSRS server, and then reboot. Simple enough! I think after this project I'm going to write a book on integrating Oracle with SSRS!!

Thanks again,
Stacy

Tony Rogerson wrote:
> If you are developing and testing the reports locally on your development
> machine then you'll no doubt have the Oracle drivers etc... set up, when you
> run the report locally it runs locally - it does not use the server
> Reporting Services.
>
> When you deploy, it deploys to the server and when you browse to the report
> it runs on the server.
>
> It a nutshell - make sure you have all the necessary connection strings,
> drivers blah blah set up and working on the server running Report Services
> and not just your development desktop.
>
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
> Server Consultant
> http://sqlserverfaq.com - free video tutorials
>
>
> <calgarydatagrl_at_gmail.com> wrote in message
> news:1156785931.211996.156100_at_i3g2000cwc.googlegroups.com...
> >I am building reports for a migration project on an Oracle 10g database
> >
> > server. I have built all my reports with text queries in Visual Studio
> >
> > .NET and setup my data source connections there, and all the reports
> > work great when I preview them there. Once I upload them to Reporting
> > Services, I get the following error:
> >
> > An error has occurred during report processing.
> > Cannot create a connection to data source 'ISRVTST1'.
> > For more information about this error navigate to the report
> > server on the local server machine, or enable remote errors
> >
> >
> > I don't know what is different... everything is setup the same. Am I
> > missing something I should be doing? I have set it up as an Oracle
> > connection type, just like in Visual Studio.
> >
Received on Thu Aug 31 2006 - 15:26:21 CDT