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 Lite 10g supports .Net Stored Procedures

Hello Team..
No I am not posting in the wrong forum, I meant to check if the MS pros have read/heard of anything about Oracle Lite 10R2 and its support for .Net Stored Procedure..
Oracle et al docs show that it only support java stored proc (on Windows 32 not CE), but do not show if it does not support .NET stored proc. the docs show that Lite 10g R2 does NOT support PL/SQL stored procs....

Can anyone please help if you have any info or reference?

Thanks

PS:
I already posted the question in 3 oracle forums...

I just recently ran into this and found out that only Java stored procs are supported with Oracle Lite 10gR2. Oracle Database 10gR2 on Windows supports .NET stored procs as a call to an external process (i.e. there is no .NET CLR in the database as with SQL Server 2005) as far as I know.

Damir

Oracle Lite 10g supports .Net Stored Procedures

Hello Team..
No I am not posting in the wrong forum, I meant to check if the MS pros have read/heard of anything about Oracle Lite 10R2 and its support for .Net Stored Procedure..
Oracle et al docs show that it only support java stored proc (on Windows 32 not CE), but do not show if it does not support .NET stored proc. the docs show that Lite 10g R2 does NOT support PL/SQL stored procs....

Can anyone please help if you have any info or reference?

Thanks

PS:
I already posted the question in 3 oracle forums...

I just recently ran into this and found out that only Java stored procs are supported with Oracle Lite 10gR2. Oracle Database 10gR2 on Windows supports .NET stored procs as a call to an external process (i.e. there is no .NET CLR in the database as with SQL Server 2005) as far as I know.

Damir

Oracle and unicode

Since the .net oracle providers are the only ones that work in x64 it is extremely annoying that it insists on mapping ALL varchar columns in oracle to wstring. Is there a way to fix this? The oledb providers don't have this problem but I don't like being forced to use the 32 bit runtime as a workaround.I remember that this has already been discussed:
I was told, that all .NET providers return UNICODE text. You have to do an explicit data conversion with ALL your fields.

@.Donald Farmer: Since you've said, that when developing SSIS it was meant to avoid implicit data conversion due to performance issues you've had with DTS, I'm wondering how this paradigm copes with this?

@.Brent: Sorry I cannot help...|||

Sorry, I didn't see that post.

I'm just having a hard time explaining to my developers why there's 18 different workarounds to get oracle to work in the first place. The last thing they want to do is explicitly map 150 different columns.

|||

Brent Mills wrote:

Since the .net oracle providers are the only ones that work in x64 it is extremely annoying that it insists on mapping ALL varchar columns in oracle to wstring. Is there a way to fix this? The oledb providers don't have this problem but I don't like being forced to use the 32 bit runtime as a workaround.

i'm not sure if this will help, but openlink has a 64 bit ole db to obdc provider: http://uda.openlinksw.com/oledb/st/oledb-odbc-st/

Oracle and Analysis Services

We have a world wide ERP built on top of Oracle and .net.

We have no way to change Oracle for SQL Server at this time.

But, we would like to use the Excel OLAP features.

From what we've seen, the OLAP features in Excel only work on top of SQL Server's Analysis Services.

Is this true?

Could we have Oracle and just Analysis Services installed?

What would be the cost of such a solution (could you point a price table)?

Thanks a lot.

Analysis Services is fully supported to build cubes based on the data in Oracle relatonal database.

Analysis Services is integral part of SQL Server product offering, you will need to obtain full licence for SQL Server product to run Analysis Services.

You are not required to install SQL Server relational engine on your machine. Installation of Analysis Serivces is self contained.

Pricing of the Analysis Services is standard pricing for buying a SQL Server licence: http://www.microsoft.com/sql/howtobuy/default.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.