I have been using Excel (2007/2010) spreadsheets as datasource for SSRS reports in SQL Server 2005. The reports ran fine using ODBC connections. Once I started using SSRS 2008 these reports stopped working. Though I was able to create the DSN and view the results in the BIDS, the reports won't work on the web. It gives the error messages below. Any ideas. Has Microsoft fixed this problem now? Thx in advance. An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source 'x'. For more information about this error navigate to the report server on the local server machine, or enable remote errors or the 4th line would be something like... ERROR [IM002] [Microsoft Driver Manager] Data Source name not found and no default driver specified. Environment: RS on Windows 2008 Server/ SQL Server 2008 64 Bit.

Hi Christal, The native jet ODBC driver only supports 32bit, you can execute DTS packages in 32-bit (WOW64) environment on 64-bit machine, and then you can use 32-bit OLEDB provider. This is the similar thread, please click this link for a reference http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/213b90cb-5aea-41be-b935-fa995b6322ca/ Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Thanks for the response. Looked at the links all the way to Todd's blog. Bit complicated with not much ROI for the time to be invested. Is Microsoft planning to resolve this OOTB with out needing any work arounds. MS complicated the 32-64 bit in many areas to begin with. Are they going to make this uncomplicated soon?

Try using the OLEDB Microsoft Office ACE provider it has a 64 bit version