Oracle problem

Has someone encountered this issue when reports are run from ORACLE datasource
I can view the reports fine in VS.net designer but when I try to view it
from RS Manager I get this erro
----
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'OracleDvel'.
(rsErrorOpeningConnection) Get Online Help
System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater.
----
Thanks
System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater.Make sure to install the Oracle client software on the report server machine
(not only on the report designer machine).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"shahab" <shahab@.discussions.microsoft.com> wrote in message
news:E59DF319-A42E-455D-AE68-10D71BE65DC8@.microsoft.com...
> Has someone encountered this issue when reports are run from ORACLE
> datasource
> I can view the reports fine in VS.net designer but when I try to view it
> from RS Manager I get this error
> ----
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'OracleDvel'.
> (rsErrorOpeningConnection) Get Online Help
> System.Data.OracleClient requires Oracle client software version 8.1.7 or
> greater.
> ----
> Thanks
> System.Data.OracleClient requires Oracle client software version 8.1.7 or
> greater.|||Thanks Rob
I am doing the both i.e the designer as well as reportserver on the same
machine. Although I have installed 9i client but still it would not let me
continue.
Any assistance would be most appreciated.
"Robert Bruckner [MSFT]" wrote:
> Make sure to install the Oracle client software on the report server machine
> (not only on the report designer machine).
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> news:E59DF319-A42E-455D-AE68-10D71BE65DC8@.microsoft.com...
> > Has someone encountered this issue when reports are run from ORACLE
> > datasource
> > I can view the reports fine in VS.net designer but when I try to view it
> > from RS Manager I get this error
> > ----
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'OracleDvel'.
> > (rsErrorOpeningConnection) Get Online Help
> > System.Data.OracleClient requires Oracle client software version 8.1.7 or
> > greater.
> >
> > ----
> > Thanks
> >
> > System.Data.OracleClient requires Oracle client software version 8.1.7 or
> > greater.
>
>|||1. Use ORACLE OLE DB PROVIDER
2. Server, Login, Password
3. Open over RS Project and use this:
- use OLE DB Generic
- Manual Modify Data Source: "Provider=MSDAORA.1;data source=XXXXXXX|||Did you reboot the machine since you installed the Oracle 9i client. There
is a known issue that ASP.NET application (like the report server) don't
"see" the Oracle 9i client right after installation without reboot.
Also make sure that the Oracle client installation directory can be accessed
(add read permissions explicitly) by the account the RS windows service is
running under.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"shahab" <shahab@.discussions.microsoft.com> wrote in message
news:1119CDBB-8C67-438E-9FA7-C585E41BB67E@.microsoft.com...
> Thanks Rob
> I am doing the both i.e the designer as well as reportserver on the same
> machine. Although I have installed 9i client but still it would not let me
> continue.
> Any assistance would be most appreciated.
>
> "Robert Bruckner [MSFT]" wrote:
>> Make sure to install the Oracle client software on the report server
>> machine
>> (not only on the report designer machine).
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "shahab" <shahab@.discussions.microsoft.com> wrote in message
>> news:E59DF319-A42E-455D-AE68-10D71BE65DC8@.microsoft.com...
>> > Has someone encountered this issue when reports are run from ORACLE
>> > datasource
>> > I can view the reports fine in VS.net designer but when I try to view
>> > it
>> > from RS Manager I get this error
>> > ----
>> > An error has occurred during report processing. (rsProcessingAborted)
>> > Get
>> > Online Help
>> > Cannot create a connection to data source 'OracleDvel'.
>> > (rsErrorOpeningConnection) Get Online Help
>> > System.Data.OracleClient requires Oracle client software version 8.1.7
>> > or
>> > greater.
>> >
>> > ----
>> > Thanks
>> >
>> > System.Data.OracleClient requires Oracle client software version 8.1.7
>> > or
>> > greater.
>>|||still no luck. I rebooted the machine and gave full control to the Oracle
client directory ...The RS is running under my own credentials but still
comes up with the same error.
"Robert Bruckner [MSFT]" wrote:
> Did you reboot the machine since you installed the Oracle 9i client. There
> is a known issue that ASP.NET application (like the report server) don't
> "see" the Oracle 9i client right after installation without reboot.
> Also make sure that the Oracle client installation directory can be accessed
> (add read permissions explicitly) by the account the RS windows service is
> running under.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> news:1119CDBB-8C67-438E-9FA7-C585E41BB67E@.microsoft.com...
> > Thanks Rob
> > I am doing the both i.e the designer as well as reportserver on the same
> > machine. Although I have installed 9i client but still it would not let me
> > continue.
> > Any assistance would be most appreciated.
> >
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> Make sure to install the Oracle client software on the report server
> >> machine
> >> (not only on the report designer machine).
> >>
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> >> news:E59DF319-A42E-455D-AE68-10D71BE65DC8@.microsoft.com...
> >> > Has someone encountered this issue when reports are run from ORACLE
> >> > datasource
> >> > I can view the reports fine in VS.net designer but when I try to view
> >> > it
> >> > from RS Manager I get this error
> >> > ----
> >> > An error has occurred during report processing. (rsProcessingAborted)
> >> > Get
> >> > Online Help
> >> > Cannot create a connection to data source 'OracleDvel'.
> >> > (rsErrorOpeningConnection) Get Online Help
> >> > System.Data.OracleClient requires Oracle client software version 8.1.7
> >> > or
> >> > greater.
> >> >
> >> > ----
> >> > Thanks
> >> >
> >> > System.Data.OracleClient requires Oracle client software version 8.1.7
> >> > or
> >> > greater.
> >>
> >>
> >>
>
>|||I am having the same problem. RS is running a new server. I've tried the
recommendations above and still get this error. Did you resolve it?
Thanks,
Neil
"shahab" wrote:
> still no luck. I rebooted the machine and gave full control to the Oracle
> client directory ...The RS is running under my own credentials but still
> comes up with the same error.
> "Robert Bruckner [MSFT]" wrote:
> > Did you reboot the machine since you installed the Oracle 9i client. There
> > is a known issue that ASP.NET application (like the report server) don't
> > "see" the Oracle 9i client right after installation without reboot.
> > Also make sure that the Oracle client installation directory can be accessed
> > (add read permissions explicitly) by the account the RS windows service is
> > running under.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "shahab" <shahab@.discussions.microsoft.com> wrote in message
> > news:1119CDBB-8C67-438E-9FA7-C585E41BB67E@.microsoft.com...
> > > Thanks Rob
> > > I am doing the both i.e the designer as well as reportserver on the same
> > > machine. Although I have installed 9i client but still it would not let me
> > > continue.
> > > Any assistance would be most appreciated.
> > >
> > >
> > > "Robert Bruckner [MSFT]" wrote:
> > >
> > >> Make sure to install the Oracle client software on the report server
> > >> machine
> > >> (not only on the report designer machine).
> > >>
> > >>
> > >> -- Robert
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> > >> news:E59DF319-A42E-455D-AE68-10D71BE65DC8@.microsoft.com...
> > >> > Has someone encountered this issue when reports are run from ORACLE
> > >> > datasource
> > >> > I can view the reports fine in VS.net designer but when I try to view
> > >> > it
> > >> > from RS Manager I get this error
> > >> > ----
> > >> > An error has occurred during report processing. (rsProcessingAborted)
> > >> > Get
> > >> > Online Help
> > >> > Cannot create a connection to data source 'OracleDvel'.
> > >> > (rsErrorOpeningConnection) Get Online Help
> > >> > System.Data.OracleClient requires Oracle client software version 8.1.7
> > >> > or
> > >> > greater.
> > >> >
> > >> > ----
> > >> > Thanks
> > >> >
> > >> > System.Data.OracleClient requires Oracle client software version 8.1.7
> > >> > or
> > >> > greater.
> > >>
> > >>
> > >>
> >
> >
> >|||I unistalled the RS and then installed it again and it worked. My situation
was that I installed Oracle clients after I installed the RS, and maybe the
RS does not recognises it.
Hope it helps
"Neil Gould" wrote:
> I am having the same problem. RS is running a new server. I've tried the
> recommendations above and still get this error. Did you resolve it?
> Thanks,
> Neil
> "shahab" wrote:
> > still no luck. I rebooted the machine and gave full control to the Oracle
> > client directory ...The RS is running under my own credentials but still
> > comes up with the same error.
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Did you reboot the machine since you installed the Oracle 9i client. There
> > > is a known issue that ASP.NET application (like the report server) don't
> > > "see" the Oracle 9i client right after installation without reboot.
> > > Also make sure that the Oracle client installation directory can be accessed
> > > (add read permissions explicitly) by the account the RS windows service is
> > > running under.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > >
> > > "shahab" <shahab@.discussions.microsoft.com> wrote in message
> > > news:1119CDBB-8C67-438E-9FA7-C585E41BB67E@.microsoft.com...
> > > > Thanks Rob
> > > > I am doing the both i.e the designer as well as reportserver on the same
> > > > machine. Although I have installed 9i client but still it would not let me
> > > > continue.
> > > > Any assistance would be most appreciated.
> > > >
> > > >
> > > > "Robert Bruckner [MSFT]" wrote:
> > > >
> > > >> Make sure to install the Oracle client software on the report server
> > > >> machine
> > > >> (not only on the report designer machine).
> > > >>
> > > >>
> > > >> -- Robert
> > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > >> rights.
> > > >>
> > > >>
> > > >> "shahab" <shahab@.discussions.microsoft.com> wrote in message
> > > >> news:E59DF319-A42E-455D-AE68-10D71BE65DC8@.microsoft.com...
> > > >> > Has someone encountered this issue when reports are run from ORACLE
> > > >> > datasource
> > > >> > I can view the reports fine in VS.net designer but when I try to view
> > > >> > it
> > > >> > from RS Manager I get this error
> > > >> > ----
> > > >> > An error has occurred during report processing. (rsProcessingAborted)
> > > >> > Get
> > > >> > Online Help
> > > >> > Cannot create a connection to data source 'OracleDvel'.
> > > >> > (rsErrorOpeningConnection) Get Online Help
> > > >> > System.Data.OracleClient requires Oracle client software version 8.1.7
> > > >> > or
> > > >> > greater.
> > > >> >
> > > >> > ----
> > > >> > Thanks
> > > >> >
> > > >> > System.Data.OracleClient requires Oracle client software version 8.1.7
> > > >> > or
> > > >> > greater.
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >