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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SSRS 2008 With Oracle Datasource

Author  Topic 

rajarajan
Starting Member

48 Posts

Posted - 2012-03-14 : 12:34:07
I have created the Oracle Data source in my local BIDS and Used in the report RDL , RDL work fine and when deploying RDl in reporting manager and assign the Created Oracle data source to the report and going to the report history tab => New Snapshot Button given me the error

“Cannot create a connection to data source My Oracle data source “

the oracle client install in the server

rajarajan
Starting Member

48 Posts

Posted - 2012-03-15 : 12:44:08
Any idea ? on the above issue
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-15 : 15:35:53
whats the service account snapshot uses? does it have access to oracle source?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -