new SSRS install, works great until I try to access Oracle datasource - System.Data.Oracle

re: new SSRS install, works great until I try to access Oracle
datasource - System.Data.OracleClient requires Oracle client software
>From my desktop the report accessing an Oracle 9i db with no problem.
I've deployed other reports accesing sql server with no problem.
Now I deploy the report and try to access my Oracle source and get:
System.Data.OracleClient requires Oracle client software version 8.1.7
or greater
On the server in question, I know they've installed the oracle client.
I can access the db from sql plus with no problem.
As the user that I access ssrs credentials, i remote login and am able
to write to oracle home.. C:\oracle\ora10g\NETWORK\ADMIN
i've confirmed my database is in tnsnames and it works from sqlplus.On Nov 5, 3:27 pm, jobs <j...@.webdos.com> wrote:
> re: new SSRS install, works great until I try to access Oracle
> datasource - System.Data.OracleClient requires Oracle client software
> >From my desktop the report accessing an Oracle 9i db with no problem.
> I've deployed other reports accesing sql server with no problem.
> Now I deploy the report and try to access my Oracle source and get:
> System.Data.OracleClient requires Oracle client software version 8.1.7
> or greater
> On the server in question, I know they've installed the oracle client.
> I can access the db from sql plus with no problem.
> As the user that I access ssrs credentials, i remote login and am abl
> to write to oracle home.. C:\oracle\ora10g\NETWORK\ADMIN
> i've confirmed my database is in tnsnames and it works from sqlplus.
This is just a guess; but, have you checked for all necessary assembly
references from the Oracle-side. I would start with maybe getting a
comparison tool (possibly 30-day trial version of Merge 2007:
http://www.araxis.com/ ) and compare the directory structure of your
machine versus the machine where the report is deployed (in reference
to Oracle 8.1.7). Also, you might want to check into the driver for
the SSRS connection to Oracle. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||If you have the Oracle client installed on the server I think the issue is
that the directory it is installed in is not accessible to RS. I googled
this a little (oracle client reporting services permissions)
http://technet.microsoft.com/en-us/library/ms159689.aspx
a.. (Optional) Install Oracle client tools on the report server if your
reports use the Microsoft .NET Framework Data Provider for Oracle. After you
install the client tools, you must restart IIS. To support subscriptions to
reports that use Oracle data sources, you must grant permissions to the
NetworkService account. For more information, see
http://support.microsoft.com/kb/870668.
http://support.microsoft.com/kb/870668
To work around this problem, add permissions for the NETWORK SERVICE
security principal to the Oracle\Oracle version\bin directory and to the
Oracle\Oracle version\network\admin directory. To do this, follow these
steps. ...
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jobs" <jobs@.webdos.com> wrote in message
news:1194298047.081192.142180@.o3g2000hsb.googlegroups.com...
> re: new SSRS install, works great until I try to access Oracle
> datasource - System.Data.OracleClient requires Oracle client software
>
>>From my desktop the report accessing an Oracle 9i db with no problem.
> I've deployed other reports accesing sql server with no problem.
> Now I deploy the report and try to access my Oracle source and get:
> System.Data.OracleClient requires Oracle client software version 8.1.7
> or greater
> On the server in question, I know they've installed the oracle client.
> I can access the db from sql plus with no problem.
> As the user that I access ssrs credentials, i remote login and am able
> to write to oracle home.. C:\oracle\ora10g\NETWORK\ADMIN
> i've confirmed my database is in tnsnames and it works from sqlplus.
>