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.
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >

Oracle data source connection problem using Report Manager

I have an issue when using Report Manager for viewing reports that use a certain Oracle data source. When viewing the reports in Report Designer the reports display without problems. But when trying to display the reports with Report Manager, after deploying the reports to the Report Server, I now get the following error message:

blablabla....ORA-12705: invalid or unknown NLS parameter value specified

For testing purposes I am running Report Designer, Report Server and Report Manager locally on a PC with Windows XP. I am using Reporting Services 2005, IIS 6, Visual Studio 2005, an Oracle 9.x client and an Oracle 9.x (not 100% sure) database that is hosted on a remote server.

Earlier I got an error message that stated "ORA-12154: TNS: could not resolve the connect identifier specified". Access rights to some Oracle folders for the Network service account did the trick here but then I got the "NLS parameter" error message. What I have tried to do is removing the NLS_LANG register variable and also modified the value of the variable so that it matches the value of the NLS_LANG variable on the server that hosts the Oracle database, but none of them have worked. Any ideas?

Maybe this is an issue that is more appropriate in an Oracle forum but what the heck..the problem could reside in Reporting Services..

Thanks, Stefan

I found the solution to the problem. I was jerking around with the wrong NLS_LANG registry variable. Everywhere I have looked it says that the NLS_LANG variable is found in the Home0 directory in the Windows registry, so naturally I have tested settings with that NLS_LANG variable. Also, the first thing I did was to search the registry for the NLS_LANG variable and the only search result was the one found under the Home0 directory. Out of coincidence, I found another NLS_LANG variable located directly under the Oracle directory in the registry. This variable was set to "NA". I changed it to AMERICAN_AMERICA.WE8ISO8859P15, and boom shakalak!

/Stefan