Reporting services Data Source to Oracle
<p>We have set up Data Source to Oracle on our SSRS 2008 reporting manager as simply:</p>

<blockquote>
  <p>Data Source: Oracle (from drop down list) Connection string: Data
  Source=SERVERNAME;Unicode=True</p>
</blockquote>

<p>And it all works fine until something happens - we assumed after windows updates.</p>

<p>This connection doesn't work. The error is:</p>

<blockquote>
  <p>"Attempt to load Oracle client libraries threw
  BadImageFormatException. This problem will occur when running in 64
  bit mode with the 32 bit Oracle client components installed."</p>
</blockquote>

<p>We do have 32bit Oracle driver on this server. I don't know if there is a 64bit one already.</p>

<p>Then we have created another one to ORacle but is ODBC:</p>

<blockquote>
  <p>Data Source: ODBC (from drop down list) Connection string:
  DSN=SERVERNAME;</p>
</blockquote>

<p>After this one is tested for connection (with the button in the properties window) the first one starts working.</p>

<p>And then we continue with the Oracle Data Source as usual and until the next failure. It happened couple of times so far and the solution is just to open the ODBC connection, hit "Test Connection", that works fine. Then go back to Oracle data source and that one works.</p>

<p>It is very unreliable to operate reporting service for the users and also annoying for staff as we don't have a solution.</p>

<p>Any ideas for what we might be looking on that server to have it working 100% of time?</p>