Reporting Services e-mail delivery extension error

Hi guys!

I am having a problem with the e-mail delivery extension in MS SQL Reporting Services 2005. I have some reports that use an Oracle data source. When running the reports through Report Manager the data source works fine and the reports display properly. But when running an automatic e-mail delivery of the reports through a subscription I get the following error message (in the ReportServerService log file):

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

Doesn't this seem strange when the reports run in Report Manager but not when I send the reports through e-mail? I have Oracle Instant client v. 10.2.0.3 installed on the machine. I am wondering if the e-mail delivery extension has an account that needs privilegies to the oracle client home directory or something like that. Any ideas?

Thanks!

/Stefan

Just providing some additional information. The Oracle data source I am using uses the connection type "Oracle". I am using the connection string "data source=mydatasource;unicode=True". I also tried out the connection type "OLE DB" and used the connection string "Provider=msdaora;data source=mydatasource;Unicode=True". When I tried this data source I got the following error message when trying to display the reports in Report Manager:

Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.

It seems that the Oracle instant client installation can't be found but I have tried to connect with sqlplus and the installation seems to work fine. Maybe there exist some unknown issue between MS SQL Reporting Services and the Oracle instant client, or there is something missing in the Oracle instant client installation?

|||

I have found the solution and it is everything else than logical.

Originally I installed the Oracle Instant Client to C:\Program Files\instantclient_10_2. This seemed to work for viewing reports in Report Manager but when I tried to deliver reports via e-mail I got the error message described above.

The other day the reports that used the Oracle data source did not display in Report Manager any longer and I got the error message above. So what did I do? I moved all Oracle Instant client installation files to C:\WINDOWS\system32 and suddenly everything worked. I don't know why but at least it works...

/Stefan