When I design a report in BIDS, querying an Access db, I get data in preview mode and everything looks fine. When I publish the report to Report Manager and try to load it I get an error: "An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server." I am using SQL Server 2005 and I used to be able to see Access data in the RepMan. Since our hardware guy rebuilt the server I seem to have lost this ability. Can someone please tell me what configuration edit(s) I need to make to fix this problem? Thanks for any help you can give me.
This could be as simple as missing Microsoft Jet 4.0 OLE DB Provider on the box after rebuild. You can check the registry: HKCR\\CLSID\\dee35070-506b-11cf-b1aa-00aa00b8de95\\OLE DB Provider If your server is rebuit as 64 bit then unfortunately there are no 64-bit OLEDB drivers and 32-bit one is not going to be registered on the box. If you can change your app to target 32-bit then you might be able to install, register and use Jet. Otherwise, you might want to consider not using Access as a backend. Oleg