Print Page | Close Window

OLE DB (ADO) Connection

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20663
Printed Date: 18 Apr 2024 at 11:23am


Topic: OLE DB (ADO) Connection
Posted By: crystalsonic
Subject: OLE DB (ADO) Connection
Date Posted: 21 Apr 2014 at 5:11am
I am trying to set up a connection to an access database via OLE DB(ADO). The problem is that I do not see the provider I need in the list. The Provider I need is:
 
Access Database Engine OLE DB Provider
 
My set up: Crystal XI, Windows 7, Microsoft Access 2010 and I downloaded the Microsoft Access Database Engine 2010 Redistributable.
 
The File type for the database: Microsoft Access Database (.accdb)
 
Any thoughts/suggestions on how I can get the Provider available in my connection set up?


Replies:
Posted By: kevlray
Date Posted: 21 Apr 2014 at 10:27am
I have Access 2007 and 2010 installed (I do not have the Access Database Engine 2010 Redistributable) and I see a Microsoft Office 12.0 Access Database Engine OLE DB Provider in the list for OLD DB (ADO) providers and I did a quick test and I can open an .accdb


Print Page | Close Window