Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 SQL Reporting Services connection

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-05-04 : 07:57:20
Steve writes "I have created a report in Visual Studio .Net using reporting services connecting to a Oracle database and it works fine. However when I deploy it and try to run the same report via SQL Reporting Services Manager, I get a connection error that says:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'MDW'. (rsErrorOpeningConnection) Get Online Help
?
I have tried recreating the connection in report manager and get the same message.
Why does it work in developer and not online? Is it a rights issue?
Thanks"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-05-04 : 08:01:35
It sounds like the report server does not have the Oracle driver(s) installed or configured properly. That should be the first thing to check anyway.
Go to Top of Page
   

- Advertisement -