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