June 16, 2015 at 12:51 pm
I'm using SSRS 2012 running off of a Windows server 2012 machine, I have a report that's pulling from an excel spreadsheet that is not saved locally on the server but in a network location.
When I try to run the report on the report site I get this error:
"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source
'Hospital_Grid'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors"
I can run the report just fine in preview from within Visual Studio 2012, the Excel data source is set up through an ODBC connection connecting to the network path where the file is. I've tried installing the 64 bit excel odbc drivers and that did not work. Ive tried setting up both the 32 bit and 64 bit odbc connection or doing one or the other and still the same error.
It seems to work fine on an older SSRS 2005 report site, but on 2012 it keeps erroring. Anyone familiar with this issue or any ideas?
June 16, 2015 at 1:48 pm
If you go to the report on the Report Manager interface, click the drop-down and select "Manage" you should be able to see the data sources the report is using. If you go to the data source and test the connection does it succeed?
Have you checked the SSRS logs?
Joie Andrew
"Since 1982"
June 16, 2015 at 2:11 pm
Yep Checked the error log (see below), its the reason why I installed the 64 bit odbc excel driver.
When testing the connection it fails with this error : "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"
From error log:
"ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'Hospital_Grid'. ---> System.Data.Odbc.OdbcException: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)"
June 16, 2015 at 2:34 pm
I have a bad feeling if you are getting an architecture mismatch to Excel using the 64-bit driver you are going to need to use the 32-bit driver.
Which means you are going to need a 32-bit version of SSRS in order to use the driver.
Joie Andrew
"Since 1982"
June 17, 2015 at 7:49 am
I was thinking the same thing, just hoping that isn't the case.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply