Connection to Oracle

Hi,

I have created a simple report that reads data from Oracle within Visual Studio. I have no problem with previewing the report within Visual Studio. When I deploy the report to the Report Server (same machine) and try to open the report through Report Manager, I get the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'xxxx'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

I am aware of the following issue that requires extra security to be assigned to the Oracle directories: http://support.microsoft.com/Default.aspx?kbid=870668

Even after applying the Read/Execute access to the Network Service account that is running the Reporting Service, I still get the error message.

Can anyone help me with the debugging of this issue?

Thanks,

Ben

To me, that error could mean a couple of things, not necessarily just read/execute problems.

Is the version of Oracle client equal to or greater than 8i? Do you have your Oracle homes set correctly (especially as you may have multiple clients installed on the same machine)? Did you propagate the read/execute permissions down the directory structure, including to the <oracle install dir>/network/admin folder and its contents? What account is IIS running under? Does your tns file have the correct entry in it? And lastly, are you running Win2K3 or a prior version - IIRC the NETWORKSERVICE account only started being used from 2K3 onwards, prior to that there may have been other identities that IIS and SSRS run under.

HTH!

|||Try updating the oracle client to 10.2.01|||

Hi sluggy,

I am currently running Windows XP Prof.

On this machine, I have 3 different Oracle clients (8.1, 9.2, and 10). Read/Execute has been propagated to all 3 directories starting from each of the Oracle_Home directory.

IIS (World Wide Web Publishing Service) is running under Local System.

TNS is correct. Both Visual Studio and the Report Server are running on the same machine.

How can you tell which Oracle Client the Reporting Service will use? I tried to direct it to Oracle 9.2 by modifying the both System Variables (ORACLE_HOME) and the registry (My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOME=C:\ORACLE\ORA92). Neither of these seems to work.

Thanks,

Ben

|||

Hi ghw123,

I currently have Oracle Client 10.2.1 on the machine. Unfortunately, I am not sure how to force the Report Service to use this client over the 2 clients that I have on the machine.

Any suggestions?

Thanks,

Ben

|||Make sure that the 10.2.01 client is listed first in the local enviroment variable 'Path'|||

Hi ghw123,

Thanks for your help. I think my problem is related to Oracle client installation.

I have reinstalled everything on a separate machine and everything works fine when I apply the proper Read/Exec rights for the account running the Reporting Service.

Thanks,

Ben