Rights Issue(?) with Oracle Reports

Hello,
we are experiencing a very strange behaviour with reporting services.
- Some of our reports use an oracle db
- when a normal user ( not an admin) calls these reports for the first time
he gets the following message after about 20 seconds:
Original:
Fehler bei der Berichtsverarbeitung. (rsProcessingAborted) Onlinehilfe
Es kann keine Verbindung zur Datenquelle 'DataSource1' hergestellt werden.
(rsErrorOpeningConnection) Onlinehilfe
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.
Roughly Translated:
Error Processing Report (rsProcessingAborted)
Cannot connect to datasource 'DataSource1' (rsErrorOpeningConnection)
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.
- Now the user calls the admin, and tells him the report does not work. the
admin clicks on the report, and for him it works.
when the user calls the report it works and will work for all users! after a
few hours it will not work anymore, and the admin would have to click ist
again.
we can reproduce this error by rebooting the machine.
- Reports using sql-server work fine, always. we have allready tried using
an ole db connection instead of an oracle connection, to no avail.
installing sp1 did not help either.
Any suggestions? I'm quite stumped to be honest.
Regards
Karsten Grombach1. Make sure you have rebooted the server after installing the Oracle
client. I have heard that it does not specify that is is necessary but it
is.
2. Turn off the worker process recycle setting in IIS. This will make sure
that it will keep working once it has started.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karsten Grombach" <karsten.nogrombach@.spam.tria.de> wrote in message
news:ud%23UtpmYEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hello,
> we are experiencing a very strange behaviour with reporting services.
> - Some of our reports use an oracle db
> - when a normal user ( not an admin) calls these reports for the first
> time
> he gets the following message after about 20 seconds:
> Original:
> Fehler bei der Berichtsverarbeitung. (rsProcessingAborted) Onlinehilfe
> Es kann keine Verbindung zur Datenquelle 'DataSource1' hergestellt werden.
> (rsErrorOpeningConnection) Onlinehilfe
> 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.
> Roughly Translated:
> Error Processing Report (rsProcessingAborted)
> Cannot connect to datasource 'DataSource1' (rsErrorOpeningConnection)
> 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.
> - Now the user calls the admin, and tells him the report does not work.
> the
> admin clicks on the report, and for him it works.
> when the user calls the report it works and will work for all users! after
> a
> few hours it will not work anymore, and the admin would have to click ist
> again.
> we can reproduce this error by rebooting the machine.
>
> - Reports using sql-server work fine, always. we have allready tried using
> an ole db connection instead of an oracle connection, to no avail.
> installing sp1 did not help either.
> Any suggestions? I'm quite stumped to be honest.
> Regards
> Karsten Grombach
>
>|||This sound like the ASP worker process is unable to load OCI.dll or other
configuration settings which are stored in the Oracle client installation
directory. For instance, the Oracle 8.1.7 client is typically installed at:
C:\oracle\ora81
Users executing reports need to have "Read & Execute" permissions at least
on \oracle\ora81\bin and \oracle\ora81\network\admin. Both directories
contain important DLLs and configuration settings. Make sure the Read &
Execute permissions are applied to all files (child objects) in those
directories (on Win2003 on the directory security tab you have to click on
the Advanced button and in the new popup window you have to select "Replace
permission entries on all child objects ..." and click OK).
If it still does not work, then try to give the users Read & Execute
permissions on the entire Oracle client installation directory.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karsten Grombach" <karsten.nogrombach@.spam.tria.de> wrote in message
news:ud%23UtpmYEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hello,
> we are experiencing a very strange behaviour with reporting services.
> - Some of our reports use an oracle db
> - when a normal user ( not an admin) calls these reports for the first
time
> he gets the following message after about 20 seconds:
> Original:
> Fehler bei der Berichtsverarbeitung. (rsProcessingAborted) Onlinehilfe
> Es kann keine Verbindung zur Datenquelle 'DataSource1' hergestellt werden.
> (rsErrorOpeningConnection) Onlinehilfe
> 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.
> Roughly Translated:
> Error Processing Report (rsProcessingAborted)
> Cannot connect to datasource 'DataSource1' (rsErrorOpeningConnection)
> 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.
> - Now the user calls the admin, and tells him the report does not work.
the
> admin clicks on the report, and for him it works.
> when the user calls the report it works and will work for all users! after
a
> few hours it will not work anymore, and the admin would have to click ist
> again.
> we can reproduce this error by rebooting the machine.
>
> - Reports using sql-server work fine, always. we have allready tried using
> an ole db connection instead of an oracle connection, to no avail.
> installing sp1 did not help either.
> Any suggestions? I'm quite stumped to be honest.
> Regards
> Karsten Grombach
>
>