Oracle connection problems (MS SQL Reporting Services)

From: <calgarydatagrl_at_gmail.com>
Date: 28 Aug 2006 10:25:31 -0700
Message-ID: <1156785931.211996.156100@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 Mon Aug 28 2006 - 12:25:31 CDT