Oracle 9i

I am trying to setup a report on the report server that connects to
Oracle 9i. The Oracle 9i client is installed on the report server, but
we still get the error: An error has occurred during report processing.
(rsProcessingAborted) System.Data.OracleClient requires Oracle client
software version 8.1.7 or greater
when running the report on the server. It ran fine in development on
my PC.
The login running the report server service also has privledges set to
the Oracle home directory on the server.
The data source uses Oracle connection type and data source=SWD1 as the
datasource.
Any suggestions would be helpful.
Thanks,
TomOn 26 Aug 2005 07:17:11 -0700, OTSolutions@.shaw.ca wrote:
>I am trying to setup a report on the report server that connects to
>Oracle 9i. The Oracle 9i client is installed on the report server, but
>we still get the error: An error has occurred during report processing.
>(rsProcessingAborted) System.Data.OracleClient requires Oracle client
>software version 8.1.7 or greater
>when running the report on the server. It ran fine in development on
>my PC.
>The login running the report server service also has privledges set to
>the Oracle home directory on the server.
>The data source uses Oracle connection type and data source=SWD1 as the
>datasource.
>Any suggestions would be helpful.
>
I have had the problem that some subdirectories of ORACLE_HOME had less
permissions than the home directory itself. "Network services" and system had
no rights at all. The bin directory was among those. Removing them from the
home directory and adding them again solved the problems.
Joachim.
--
This post is free post; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
Joachim Verhagen
http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||Thanks for the tip. I have been going nuts trying to get the Oracle client
working properly on the server. The data source/report works fine on the
development machine but it wouldn't work when I deployed it.
Incidentally, I gave Network Service permissions to the entire client home
of the Oracle 10g installation to solve the problem.
"Joachim Verhagen" wrote:
> On 26 Aug 2005 07:17:11 -0700, OTSolutions@.shaw.ca wrote:
> >I am trying to setup a report on the report server that connects to
> >Oracle 9i. The Oracle 9i client is installed on the report server, but
> >we still get the error: An error has occurred during report processing.
> >(rsProcessingAborted) System.Data.OracleClient requires Oracle client
> >software version 8.1.7 or greater
> >when running the report on the server. It ran fine in development on
> >my PC.
> >
> >The login running the report server service also has privledges set to
> >the Oracle home directory on the server.
> >
> >The data source uses Oracle connection type and data source=SWD1 as the
> >datasource.
> >
> >Any suggestions would be helpful.
> >
> I have had the problem that some subdirectories of ORACLE_HOME had less
> permissions than the home directory itself. "Network services" and system had
> no rights at all. The bin directory was among those. Removing them from the
> home directory and adding them again solved the problems.
> Joachim.
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen
> http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>