I have created a SSRS report that connects to an access database using the following OLE DB connection string:
The report works like a charm when using the development studio (MS Visual Studio) but it does not connect once deployed. I get the following error message:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DateSource'. (rsErrorOpeningConnection)
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
We have 64bit SSRS installed on a 64bit 2008 ms server. I only have the 32bit drivers for access, which I am guessing is the problem. Are the 64bit access drivers available?