title: The selected data extension ORACLE is not installed or cannot be loaded
body: <p>Our former SSRS base on Windows Server 2010 / SQL Server 2008 R2 / Oracle 11g 64 bit, to present data from Oracle database, it had been worked fine.</p>
  
  <p>After we updated to Windows Server 2012 / SQL Server 2016 / Oracle 12 ODAC 64, then some reports with many parameters, when running show error as: </p>
  
  <blockquote>
    <p>Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)</p>
  </blockquote>
  
  <p>After removing the parameters then can run normally.</p>
  
  <p>All report's dataset edition in Report Builder show error: </p>
  
  <blockquote>
    <p>The selected data extension ORACLE is not installed or cannot be loaded.  Verify that the selected data extension is installed on the client for local reports and on the report server for published reports.Microsoft.ReportingServices.Designer.Controls)</p>
  </blockquote>
  
  <p>I had tried to uninstall oracle client 11 then install ODAC121024_x64, later ODTwithODAC121024 (<a href="http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html" rel="nofollow noreferrer">http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html</a>), but all did not work.enter image description here</p>
  
  <p>Now all reports modification are pending, Can expert give me suggestion and idea?</p>
  
  <p>Many thanks in advance!</p>