<div>
<div class="content wysiwyg-content">
Hi, 
 
I have created a SSRS report that connects to an access database using the following OLE DB connection string: 
 
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&quot;\\Folder\Database.accdb&quot; 
 
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? 
 
Thanks, Greg
</div>
</div>

Hi,

I have created a SSRS report that connects to an access database using the following OLE DB connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="\\Folder\Database.accdb"

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?

Thanks, Greg

SSRS 64bit - Connect to Microsoft Access

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.