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.

Ask Microsoft.

The one thing I can tell you is that the implementation of the SQL Server reporting against Oracle is so flawed it couldn't have been a mistake.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org