December 3, 2009 at 9:59 am
Is there a way to change a SSRS 2008 project to x86 so it can use the Jet.OLEDB.4.0 provider? Or is there another type of connection I should use in SSRS to access an Excel file on a 64 bit server? Currently using a .xls as source, but can convert to .xlsx if that will help.
Thanks!
December 20, 2009 at 9:09 pm
Not sure if this will help or not.
I had a sharepoint site that host a asp.net page that read data from an excel file.
To get around the 64 bit issue, I created a web service that ran under an app pool that was set to run as 32 bit.
Then the provider would run as 32 bit and I was still able to run sharepoint as 64 bit.
You could try creating a web service to read the data into a datatable and return that to your report.
FYI, xls and xlsx files use different oledb providers to ready.
Chris
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply