2383433 - Where is the ADODB driver that DataSets use in Crystal reports for Visual Studio and Office 365

SAP Knowledge Base Article - Public

2383433 - Where is the ADODB driver that DataSets use in Crystal reports for Visual Studio and Office 365

Symptom

In a .NET application I am using Microsofts ADODB assembly so I can create an DataSet (DS):

using ADODB;

When I try to build the project I get an error indicating the assembly cannot be found.

Environment

  • Crystal Reports for Visual Studio
  • Office 365

Resolution

Office 365 is "cloud" based and therefore it does not include any of the MDAC drivers that were previously shipped in full Office products, Office 2010, 2013 etc.

To get the Office ADO drivers see this Microsoft article:

https://support.microsoft.com/en-ca/kb/2874601

What you need is the Office 2010 OR 2013 runtime package:

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=13255

Microsoft Access 2013 Runtime
http://www.microsoft.com/en-us/download/details.aspx?id=39358

See Also

using OLEDB.net, cr for vs, office 365

Keywords

KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio