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.

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


David Fitzjarrell

.

Relevant Pages

  • Re: How do I display data from an SQL server in SharePoint?
    ... I wanted to use Windows authentication because the database allows all Domain ... The Configure Database Connection dialog has 4 options. ... SharePoint Portal Server). ... >> create a database connection in the Data Source Catalog, ...
    (microsoft.public.sharepoint.windowsservices)
  • Sharepoint Acess Database connection
    ... | setting up a Data Source connection in Frontpage to connect to a Access DB ... "server error: An error occured while retrieving the list of databases from ... "Db Name" the web server cannot connect to the specified data source because ... or you web site is behind a proxy server or firewall. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Changing ODBC datasource for a Pivot Table
    ... Connection is the connection string and will show the table you are using. ... > the name of our server, and since the Pivot tables weren't created ... I can't simply update the DSN with the new server name ... > Select External Data Source, ...
    (microsoft.public.excel.programming)
  • Re: Changing ODBC datasource for a Pivot Table
    ... Connection is the connection string and will show the table you are using. ... > the name of our server, and since the Pivot tables weren't created ... I can't simply update the DSN with the new server name ... > Select External Data Source, ...
    (microsoft.public.excel.misc)
  • Re: MailMerge
    ... need to consider modifying any ODBC DSNs and other ... .udl and .odc) that refer to the server name. ... data source is not there, Word will display an error message. ... mind is that if you try to get existing connection details using ...
    (microsoft.public.word.mailmerge.fields)