Re: Oracle connection problems (MS SQL Reporting Services)

calgarydatagrl_at_gmail.com wrote:
> 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.

This is usually a permissions issue within MSRS and not an Oracle issue. Talk with your MSRS administrator.

David Fitzjarrell Received on Mon Aug 28 2006 - 14:26:32 CDT