.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

2008 SSRS (R2) Oracle Client issue

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server


We have installed SSRS 2008 R2 on 64 bit windows 2003 server, and the 64 bit oracle client to connect to oracle databases.  The tnsping, and SQL plus are working from the server.  But when we trying to access the same database from report manager using new Datasource, we will get the below error.

"Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed."

We have installed only the 64 bit oracle client, and the Oracle folders are given with proper permissions to access it for SQL serving account which is used to run SSRS.

Any help greatly apprciated.  Thank you.

View Complete Post

More Related Resource Links

SSRS 2008 Conditional Column Visibility Whitespace Issue

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

SSRS 2008 Paging Issue 0 of 0

I have several reports that are many pages long when rendered in visual studio, but when rendered on the web client it show pages 0 of 0 with the next and last buttons disabled. Only the first page is displayed but if I export to any format it renders all the pages correctly. Please help!

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 ....    

SSRS 2008 with Oracle

Hey all, Quick question. I'm getting ready to configure a SSRS 2008 instance and most of the data I'll be accessing is in an Oracle DW. The SQL Server instance is running on a Win2k3 server. Do I need to install Oracle client on this is server? Are there any other considerations for configuring ssrs with Oracle? Thanks!

SSRS 2008 web portal issue, urgent!!

I created a report using reporting services 2008, now I want to upload the report into the web portal so that users can start running the report from the web browser. When I opened the http://server1/ReportServer url from the browser, I just see the below, I installed full version of reporting services 2008, so I am trying to figure out what piece is missing from the installation. Please advice. Thanks. server1/ReportServer - / --------------------------------------------------------------------------------       Friday, January 02, 2009 4:15 PM        <dir> Data Sources    Tuesday, January 20, 2009 10:13 PM        <dir> HR      Friday, January 02, 2009 4:15 PM        <dir> Accounting --------------------------------------------------------------------------------Microsoft SQL Server Reporting Services Version 10.0.1600.22 sqldev

SSRS in place upgrade from 2005 to 2008 issue


I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

SSRS 2008 formatting issue - different in visual studio preview/pdf/excel vs. internet explorer


The formatting of the report is perfect when viewed in Visual studio and also after exporting it to pdf or excel. But when I deployed my solution and opened it on IE/Firefox there is a lot of problem in formatting. Specifically the row height is giving me a problem. I manually entered them to be 0.1in and made the CanGrow field as false to force that row height but some rows in the tablix expand ( to 0.15in, which is the height of my header). This is true for a matrix as well. Is there is a feature to lock the row height in IE o any other web browser?


Font/letter spacing issue when printing from SSRS 2008 report page


We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

Strange issue with a huge SSRS 2008 report (supposed to return 3 million records)



NOTE: The strange part (as mentioned in title) will come in the end.

I am running a SSRS 2008 report which fetches 3 million records from a remote server. After around 1 hour the report processing stops and I see an error icon on the lft bottom of the browser window. When I click on that to see the error details it shows some PageRequestManagerSQLErrorException with an unknown error message with code 12029 (sometimes 12002).

When I see the reportserver logs there is an error message logged in it which says "Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached."

The <DatabaseQueryTimeOut> value in the report server configuration file is already having a value set to 7200 seconds(2 hours).<

Issue with multi valued parameters in SSRS using Oracle data source


Hi All,

I have a dataset which is getting data from oracle datasource and my Dataset query expression is

="select To_Char(Time_Stamp,'Month') as Month, Node_Name as Device,Connection,MSNAME,Monitor,Avg as Average,Max as Maximum FROM OracleDataVW where ((monitor='X' and msname in ('Y')) or (MONITOR = 'CPU Utilization' AND MSNAME = 'utilization')) and TO_Char(Time_Stamp,'Mon YYYY') in  ('"+ Join(Parameters!Parameter1.Value,",") +"')"

My parameter is multiValued parameter. The above query is working good if i select one value,however if select more than one value or all it is not giving me the data. I tried to put Ltrim and Rtrim in Join but it is giving me another syntax error.

Please help me with this

Issue with Excel and Word Export - SSRS 2008


Hi there,

          I have created fairy simple report having a table in body section and Header, Footer. I have set the Report Properties

Orientation - Landscape

Paper Size - Custom

Width - 11in & Height - 8 in

Margins - Left 0.25 in , Right 0.25 in, Top 0.5 in, Botton 0.5 in

Issue NO 1: When i export the report to Excel, it takes margin as Left 0.75 in , Right 0.75 in, Top 1 in, Botton 1 in, because of this some part of my Report is cut. what should i do to keep margins of Excel as per margins set in RDL.

Issue No 2: In Footer excel shows Page 1 of 1 for all the pages

Expression used :



"Page" & Globals!PageNumber & " of " & Globals!TotalPages;

Issue No 3: when i export the Report to word, it does not consider landscape and show only middle part of report, cut rest of the report data.

SSRS 2008 w/CU6 - Parameter Default Value Refresh Issue.



We are experiencing trouble with a parameter default value (parameter 2) not refreshing when it's parents parameter value is updated (parameter 1).  The problem parameter (2) has specified values in the available values, and has a dataset that loads the default values depending a parameter above it.

The first time that parameter 1 is selected, parameter 2 is updated with the correct default value... BUT, when parameter 1 is changed, parameter 2 does not update.

If I change the problem parameter's (2) available values to the dataset where the default values come from, it works fine, but that doesn't fill the business requirement of this report.  I also tried setting parameter 2 properties to "always refresh" but that doesn't appear to refresh the default values.

What else can I try?








Error deploying SSAS 2008 cube connected to oracle client


I've build a cube in BIDS 2008 on Windows 7 machine connecting to oracle data source. I've 32-bit oracle client on my machine. I'm able to create the data source, data source view, cube successfully. I can also explore the data in data source view. But when I try to deploy the cube on my SSAS 2008 server, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.;An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B).


Errors in the high-level relational engine. A connection could not be made
to the data source with the DataSourceID of '', Name of ''.

Errors in the OLAP storage engine: An error occurred while the dimension,
with the ID of '', Name of '' was being processed. <

Page numbering issue in SSRS 2008 R2 when converting to PDF

For rdl files created in SSRS 2008, the page numbering will render Page 1 of 0 but only for PDF.  Using OverallTotalPages instead of TotalPages only works on a 2008 R2 server.  On 2008, OverallTotalPages causes an error.

How do I get the page numbering to work on PDF without using OverallTotalPages?  I need to be able to change the files, do testing, then updgrade the SSRS instance.  I can't break existing SSRS 2008 reports.



Sharepoint 2010 and SSRS 2008 R2 deployment issue and Globals!ReportName issue


1. Does Sharepoint 2010 in integrated mode Support =Globals!ReportName

Or is there any equivalent of the above expression to work in sharepoint


2. I tried to Deploy Reports from BIDS 2008 to Sharepoint 2010. No matter what settings i choose for OverWriteDatsources, it always redeploys the Datasources.




~~ Mark it as Answer if you find it correct~~

datatype tranformation issue in oracle to sql 2008 migration using SSIS


Hello friends

I am doing oracle to SQL2008 R2 migration and i want to use SSIS.

Oracle has mainly three datatypes DATE, VARCHAR2 and number. 

I tried without using the transformation it worked but the datatypes like date did not changed to datetime in sql server, even the number datatype remain same.

secondly while doing very first time i got very weired name of the table on sql side. 

Instead of going to dbo schema it shows the name like tom\myname.A_RETURNS.

So how can i resolve both the datatype and naming issue?

Thanks in advance..


SSRS 2008 R2 Sub Report Issue


Hi ,

I have two reports . F102  and F103. We need to make F103  as a sub report to F102.

Issue is facing with the sub report.

Getting the following error.


Data retrieval Failed for sub report sub report2.  Located at  /Example subreport. Please check the log file for more information


When checked the Microsoft, got the information that, it will be solved by Cumulative update package 3 for Sql server service pack1. Have downloaded the cumulative update package 3(KB971491) . But unable to install . It is showing the following error



There are no SQL SERVER instances or shared features that can be updated on this computer


I have installed sql server 2008 r2 in my system.  Already service pack1 (SP1) is installed in my system.

Questions are

1. Do I need to uninstall sp1 and reinstall sql server cumulative package 3 in my system?


Thanks & Regards






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