.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Selecting ODP.NET (provider for Oracle) in Reporting Services 2008 R2 x64, Report Builder 3.0, Busin

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :Sql Server
We have a requirement to connect Reporting Services 2008 R2 x64 + Report Builder 3.0 to Oracle database and also to build a web application which connects to Oracle. I installed ODAC (Oracle Data Access Components) which contains ODP.NET (Oracle Data Provider for .NET) and Instant Client (required by the provider). Now the problem is how to make Report Designer, Reporting Services and Report Builder 3.0 to add ODP.NET as an Oracle provider in the drop down list contained by the Data Source Wizard? I found out that Reporting Services and Report Builder work based on Data Extensions so I added Oracle.DataAccess as extension to RsReportServer.config and RsReportDesigner.config as shown in: http://www.bigresource.com/Tracker/Track-ms_sql-aIXqXMEE/. By changing RsReportDesigner the ODP.NET appeared in the list for Report Designer (Business Intelligence Studio) but it couldn't be used because an error was thrown as soon as Test Connection was pressed stating that the provider is not registered with the application. With these changes ODP.NET does not appear in the list of providers for Reporting Services and Report Builder 3.0. For now I managed to connect to Oracle through .NET Provider for Oracle (provided by default) but this seems to be deprecated and in Report Builder 3.0 I can't select tables to be added to the query, I'm prompted only with a blank textbox and one excla

View Complete Post

More Related Resource Links

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

How to set the IP addresses for teh report server on sql server 2008 reporting services

How to assign IP address to report server on 2008 version, i don't see nothing on IIS. I have installed sql server / report server 2008 on windows 2003 server. I don't see no info in IIS, can you please help, Also how to check the configuration files i remember in 2005 version i still have to open teh configuration file in notepad and do some modifiications with teh http://local to http://IPaddress etc. Thanky ou very much for the help ful info.  

Server 2008 R2 64 bit, SSRS 2008 64 bit with Report Builder 3.0 issues with Oracle OLE Driver

Folks, ran out of idea on this issues. Setup as shown at the Title. I can connect via VS 2010  but report builder cannot run properly when setup with connection string. I use a 32 bit Oracle Driver and VS 2010 works well with it, however, Report Builder on SSRS report a bad image issues while attempting to use the same driver. What have been tried: 1-Already attempted to try to download Oracle ODP drivers 64 bit, but current driver 11g and minor version above 11g does not install, installation failed. So far all chats indicated that Server 2008 R2 does not have a Oracle 64 bit driver provided y Oracle. Any help is appreciated ....    

SQL 2008 Reporting Services Report Parameter and Analysis Services issue after upgrade

I have upgraded my SQL 2000 database and analysis server and SQL 2005 reporting services server to a new instance of SQL 2008 running database engine, analysis services and reporting services.

The analysis services database migrated successfully and I have got the database into a state where it processes fine but I am having the following problems.

- My Reports show in reporting services but the drop down list parameters are all empty.
If I change the parameter in report builder to use the display name instead of the uniquename then the drop down list populates and works until I select a value that contains a space character and then it reports a problem with the dataset used by the report.

Query for the dataset used to populate my parameter.
with member [Measures].[GroupUniqueName] as '[Site].CurrentMember.UniqueName' member [Measures].[GroupDisplayName] as'[Site].CurrentMember.Name' select { [Measures].[GroupUniqueName], [Measures].[GroupDisplayName] } on columns, { [Site].[Group].members } on rows FROM [Invoice Reporting]

Query used by the report, filtering on the selected parameter value from the drop

SQL Server 2008 R2 Reporting Services - How to I run a report and save the output as a .pdf on the s


I have the source code for doing what I want to do using a previous version of SSRS.  Since the new release, the service seems to work differently as I can't find any of the methods in the WSDL:

//Validate txtEmail for inputting

lblPrompt.Text="You must enter a valid email address!"

lblPrompt.Text="You must enter a valid email address!"

//Get report

TimeSheet.wdsg_svr003.ReportingService rs=new


Reporting Services 2008 report integration in a gadget


Hello everybody,

I would like to distribute a small report I have made in Reporting Services which contains only one graph by using a Windows 7 Gadget. Does anybody know how to integrate a MS SQL Reporting Services 2008-report in a gadget?

Your answers are greatly apreciated.


Kind regards,


Reporting Services 2008 R2 - slow response on first report and after a certain timeout period


We are using Reporting Services 2008 R2.

We have a Windows Forms client with a main form using a webbrowser control to display the report Home page provided by Reporting Services.

We are finding that the loading of this page is very inconsistent. The first time we load the Windows Forms client at the start of the day the page takes too long, more than 10 seconds. After the first access, the Home Page displays in less than a second. If we don't access the Reporting Services for 20 minutes (estimate), we are back to the 10 seconds for initial load. Can someone explain what is going on?

We have tried to create a subscription to a simple report, this didn't help. We tried to create a console app to make a web request to the reporting services url every 10 minutes, this didn't help. We have looked at the rsreportserver.config and the RecycleTime entry put that doesn't really make sense why this would need to be increased considering it's at 12 hours by default. The issue that we seem to be having is happening on a shorter interval.

Does anyone have any suggestions?

Thank you!

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

Excessive Deadlocking Reporting Services 2008 Integrated.

Hi, we have a major issue with deadlocking on our reporting Server TEMPDB (REPORTSERVERTEMPDB). The platform is a Sharepoint Integrated platform allong the following lines 2 WFE Servers (NLB) 2 Sharepoint application servers 2 SQL Reporting Services (NLB) Cluster hosting Sharepoint DB's Cluster hosting Reporting Services DB's and the Data. This error is occuring for both manually running reports via sharepoint and load testing, and is happening on our testing platform as well which is slightly different in configuration. Reported back to the users is "An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database" Running a profile with 1224 set, we are finding deadlocks on the REPORTSERVERTEMPDB on PK_SNAPSHOTDATA. We have tried the following 1. Dropping the PK - The deadlock was then showing an OBJID which we could not identify. 2. Change the database properties to READ-COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to ON 3. Re-create and change the PK to ALLOW_PAGE_LOCKS OFF None have these have had an impact on the issue This has become apparent since the following actions were taken 1. The setting of caching has been enabled by the developers 2. The Report Server DB's were moved from the Sharepoint Cluster to the Data Cluster. I do have an XDL file from Profiler but it is to

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

SQL Server 2008 Install failure - Reporting Services Rule Failures

I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n

Coloring sql reporting services report depending on the change of value of a certain field

Hey guys, I have an SSRS report that looks something like this: Column1 Column2 Row1 2 A Row2 2 B Row3 2 C Row4 6 A Row5 11 E How can I color the rows with the same value in Column1 with the same color? for example Row1 to Row3 would have one color, Row4 would have a different color, then I'd go back to Row1's color for Row5? note: I don't know in advance the numbers returned in Column1. I query for them and then I hide them from the user so Column1 shouldn't show on the report, but I want to use it for the coloring only.

Windows service can't use Reporting Services on SQL Service 2008 R2

Hello. I have a Windows service that run as Local System account. The service uses the Reporting Services ReportService2005.asmx web service. When I have SQL Server 2008 installed, I have no problems and my service is able to browse and create report. After I have installed SQL Server 2008 R2 I get the error "The request failed with HTTP status 401: Unauthorized." when the service tries to use the web service. If I change my service to log on as a user with administrator rights, it is able to use Reposting Services again. What has changes in SQL Server 2008 R2, that doesn't allow the Local System account to use Repoting Services? And is it possible to configure Reporting Services to allow it?   - Per

SSRS 2008 R2 - Query builder freezes and needs to be shut down Report Builder 3 when attempting quie

Hi, In SSRS, using Report Builder 3.0 (SSRS R2), after choosing a Report Model as the report's embedded data source, launched "Query Deisinger…" from GUI to build data source in report.  First 1-2 attempts at querying underlying data source (Oracle back-end), are successful, but later attempts freeze application to the point where application freezes and overall Report Builder application needs to be forcibly shut-down. This system freeze has occurred when referencing tables containing a very small number of records as well as larger data sets.  Suspect that application freezing may be caused by timing-out of connection to back-end database. but I am not sure. Any suggestion to solve this issue? Thanks   Environment - Distributed deployment Server1(report_srv) --Windows server 2003R2 64bit, Installed sql server 2008R2 reporting service, configuration tools Server2 (report_db_srv) --windows server 2003r2 64bit, sql server 2005 for report server database

Report Builder vs Oracle Discoverer

Hello, I need some information about Report Builder (SSRS 2005) vs Oracle Discoverer. Our data source are at 80% Oracle, but our user don’t like very much Discoverer. We have a data warehouse with OLAP system in SSAS (relational data mart in Oracle), reports and dashboards SSRS and Performance Point. Our idea is to change report tool from Discoverer to Report Builder. Many thanks
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend