Error when trying to deploy a report using Oracle data source

We use SQL Server Reporting Services, My SQL box is on Win2k3. The developer
is able to run the report on his Windows XP box but when he deploys the
reports to the SQL Server where Reporting Services is running, he gets the
following error:
"An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'WMS'. (rsErrorOpeningConnection)
Get Online Help
System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater
He develped this report on his XP box using Visual Studio .NET and is trying
to deploy it to our SQL server production box where Reporting Services is
installed. I have installed Oracle 9.2 client on the SQL Server box and can
make successful connections to our Oracle Database (where the report is
pulling data from). What else am I missing?
Thanks!
Bea Isabelle, Database AdministratorI used the google groups search.
Look at this link:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8eb65eca58e11586/05b5299775c955b9?q=oracle+8.1.7+group:microsoft.public.sqlserver.reportingsvcs&rnum=1&hl=en#05b5299775c955b9
Basically reboot after installing. Link has other things to try.
Here is the search I used:
http://groups-beta.google.com/groups?hl=en&lr=&safe=off&num=10&q=oracle+8.1.7+group%3Amicrosoft.public.sqlserver.reportingsvcs&safe=off&qt_s=Search
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"isabelle" <isabelle@.discussions.microsoft.com> wrote in message
news:66AE92CA-13A2-4FB2-96B4-9CE0464D141E@.microsoft.com...
> We use SQL Server Reporting Services, My SQL box is on Win2k3. The
> developer
> is able to run the report on his Windows XP box but when he deploys the
> reports to the SQL Server where Reporting Services is running, he gets the
> following error:
> "An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'WMS'.
> (rsErrorOpeningConnection)
> Get Online Help
> System.Data.OracleClient requires Oracle client software version 8.1.7 or
> greater
> He develped this report on his XP box using Visual Studio .NET and is
> trying
> to deploy it to our SQL server production box where Reporting Services is
> installed. I have installed Oracle 9.2 client on the SQL Server box and
> can
> make successful connections to our Oracle Database (where the report is
> pulling data from). What else am I missing?
> Thanks!
> Bea Isabelle, Database Administrator
>|||Unfortunately, my server access won't allow me to go to those links here from
work. The only
that we haven't tried is rebooting the IIS services as the documentation
noted. I've also installed the ODP .Net
driver on the FFSQL box and he still gets the error. We will try a reboot
later today and see if that clears up the error.
Thanks!
"Bruce L-C [MVP]" wrote:
> I used the google groups search.
> Look at this link:
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8eb65eca58e11586/05b5299775c955b9?q=oracle+8.1.7+group:microsoft.public.sqlserver.reportingsvcs&rnum=1&hl=en#05b5299775c955b9
> Basically reboot after installing. Link has other things to try.
> Here is the search I used:
> http://groups-beta.google.com/groups?hl=en&lr=&safe=off&num=10&q=oracle+8.1.7+group%3Amicrosoft.public.sqlserver.reportingsvcs&safe=off&qt_s=Search
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "isabelle" <isabelle@.discussions.microsoft.com> wrote in message
> news:66AE92CA-13A2-4FB2-96B4-9CE0464D141E@.microsoft.com...
> > We use SQL Server Reporting Services, My SQL box is on Win2k3. The
> > developer
> > is able to run the report on his Windows XP box but when he deploys the
> > reports to the SQL Server where Reporting Services is running, he gets the
> > following error:
> >
> > "An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'WMS'.
> > (rsErrorOpeningConnection)
> > Get Online Help
> > System.Data.OracleClient requires Oracle client software version 8.1.7 or
> > greater
> >
> > He develped this report on his XP box using Visual Studio .NET and is
> > trying
> > to deploy it to our SQL server production box where Reporting Services is
> > installed. I have installed Oracle 9.2 client on the SQL Server box and
> > can
> > make successful connections to our Oracle Database (where the report is
> > pulling data from). What else am I missing?
> >
> > Thanks!
> >
> > Bea Isabelle, Database Administrator
> >
>
>