[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSRS 64bit - Connect to Microsoft Access

Posted on 2014-07-16
1
Medium Priority
?
1,312 Views
Last Modified: 2014-07-17
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
0
Comment
Question by:spen_lang
1 Comment
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 40200151
You can get the 64bit drivers here:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

Jim.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question