May 5, 2008 at 12:11 pm
I successfully created a Report model against Oracle DB and deployed it to the local server.( http://localhost/ReportServer)
When I run a preview in Report Builder I get the error below:
Microsoft Report Builder
Report execution error.
The report might not be valid or the server could not process the data.
*******************************************************************
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
*******************************************************************
Cannot create a connection to data source 'dataSource1'.
----------------------------
An error has occurred during report processing.
I have Oracle 10g client installed on my machine.
Thanks for any help!
May 10, 2008 at 1:58 pm
This error is related to permissions in the Oracle home folder, it is a bug so to avoid it we put the TNSNAMES.ORA in our development folder in .NET 2.0. Check the link below for how to apply the permissions needed.
http://www.dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx
Kind regards,
Gift Peddie
May 12, 2008 at 11:26 am
Gift Peddie,
Thanks a lot for your help!
It works now!!
Best,
Emma
May 12, 2008 at 2:37 pm
I glad I could help your posting tells me Oracle is not do all it could to fix this bug because it provided a fix in ODP.NET in 11g but Reporting Services does not use ODP.NET so Oracle system wide fix is needed not just ADO.NET provider.
Kind regards,
Gift Peddie
May 12, 2008 at 2:58 pm
Gift Peddie -
Thank you for an additional information regarding this issue!
Emma
June 18, 2008 at 7:34 am
Hi,
Gift Peddie (5/10/2008)
This error is related to permissions in the Oracle home folder, it is a bug so to avoid it we put the TNSNAMES.ORA in our development folder in .NET 2.0. Check the link below for how to apply the permissions needed.http://www.dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx
Can you give details on the "development folder in .NET 2.0" ? I get the same error but I am not allowed to change Security values. Thanks,
a+,=)
-=Clément=-
Configuration :
Windows XP SP3 Pro
June 18, 2008 at 9:13 am
You are not changing any security values my Oracle was in Florida and I was in Michigan. Tell your DBA to give you the TNSNAMES.ORA file and you put it in the folder where you put your solution files.
Kind regards,
Gift Peddie
June 18, 2008 at 9:44 am
Thanks,
Gift Peddie (6/18/2008)
You are not changing any security values my Oracle was in Florida and I was in Michigan. Tell your DBA to give you the TNSNAMES.ORA file and you put it in the folder where you put your solution files.
The problem was resolved by restarting the Reporting Services service on the server. It seems that Reporting Services service's process record a cache version of the TNSNAMES.ORA somewhere. As the TNSNAMES.ORA had changed without Reporting Services beeing restarted, Report Builder could not work. I think the datasource1 error message instead of a "please restart reporting services" is another microsoft humor proof...
a+, =)
-=Clément=-
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply