Re: Oracle connection problems (MS SQL Reporting Services)



calgarydatagrl@xxxxxxxxx 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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.



Relevant Pages

  • RE: Unable to Veiw Performance Reports after WSUS was removed
    ... SQL database for monitoring component. ... Open Server Management. ... Click Set Up Monitoring Reports and Alerts. ... Reporting wizard to configure the monitoring component. ...
    (microsoft.public.windows.server.sbs)
  • Re: why>?
    ... it's a component in the standard office installation; ... to use a 'standard office install' feature if there's not even any ... That's nice when running things on the server. ... Calculations aren't the same thing as reports unless you (and I'll ...
    (microsoft.public.excel)
  • SUMMARY: Usage reports
    ... Hobbit can monitor CPU usage, warn you when the load is too high, and it ... hobbit) is that it has all the server stuff ... Betreff: Usage reports ...
    (SunManagers)
  • RE: Unable to Veiw Performance Reports after WSUS was removed
    ... SQL database for monitoring component. ... Open Server Management. ... Click Set Up Monitoring Reports and Alerts. ... Reporting wizard to configure the monitoring component. ...
    (microsoft.public.windows.server.sbs)
  • Communication problem b/w ISA and DC
    ... authentication process done automatically among client, ISA and DC. ... connection failure. ... Event viewer reports Event Id: ... Antivirus 10 corporate edition on the same server. ...
    (microsoft.public.windows.server.sbs)