Solved

Sql ssrs Error when giving datasource as oracle

Posted on 2008-10-30
1
525 Views
Last Modified: 2008-11-02
I am using sql server 2005 version and oracle 9i .I am developing a ssrs where datasource is oracle.Everything is working fine when i preview the report but after deploying the report,which is succesfully getting deployed.When i open  to http://localhost/reportserver to view the report i get the error below.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
0
Comment
Question by:srirama_rao
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 26

Accepted Solution

by:
Zberteoc earned 500 total points
ID: 22851747
You have an old version of oracle client on the deploying server apparently. Download and install a newer one:

http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Job Hung 17 37
SQL Server Trigger 8 37
Many to one in one row 2 40
Trouble installing msi file with msiexe.exe 2 18
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question