Error while viewing the report

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  March 16, 2009 at 11:30 am

  #219162

  Hi,

  we have sql server 2005 reporting services installed. Reports were deployed and when viewing the reports getting the below error.

  An error has occurred during report processing. (rsProcessingAborted)

  Cannot create a connection to data source 'ABC'. (rsErrorOpeningConnection)

  System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

  The data from the reports is coming from for oracle database. Do I need to install something on my SSRS server?

• denglishbi

  SSCrazy Eights

  Points: 8831

  More actions

  March 16, 2009 at 1:45 pm

  #960551

  You need to install and configure the Oracle client tools on your SSRS front-end servers.

  ----------------------------------------------------------------------------------------
  Dan English - http://denglishbi.wordpress.com

• vsperla

  Old Hand

  Points: 349

  More actions

  March 20, 2009 at 9:35 pm

  #963911

  I had the Same Problem Earlier when i am Accessing the Oracle DB.If you Install new Oracle Drivers on the Rs Hosting Server.you Should be Fine.

  Let us if it Didn't Work for you.