Re: Oracle connection problems (MS SQL Reporting Services)

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.

>