question

user-687 avatar image
user-687 asked

SSRS 2008 64 bit and Excel

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 very much, mkpost

sql-server-2008ssrs
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Rob Farley avatar image
Rob Farley answered

I think the easiest way is to install a 32-bit version of SSRS. You can easily use the same ReportServer database as before (restoring the Encryption Key).

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Håkan Winther avatar image Håkan Winther commented ·
I think it is currently the only way, until the release of Office 2010
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.