Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'

This exception was originally thrown at this call stack:
    [External Code]
    DataBaseDemoWithAccessVC.ManageEmployeesForm.GetEmployeesList() in ManageEmployeesForm.cs
    DataBaseDemoWithAccessVC.ManageEmployeesForm.LoadDataIntoDatGrigView() in ManageEmployeesForm.cs
    DataBaseDemoWithAccessVC.ManageEmployeesForm.ManageEmployeesForm_Load(object, System.EventArgs) in ManageEmployeesForm.cs
    [External Code]


What I have tried:

DataTable dtEmployees = new DataTable();
           string connString = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString;
           using (OleDbConnection conn = new OleDbConnection(connString))
           {
               using (OleDbCommand cmd = new OleDbCommand("SELECT * FROM Employees", conn))
               {

                   conn.Open(); // error at this line
Posted
Updated 1-May-20 9:27am

If only someone could have already met the same issue and asked about it:
.net - 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - Stack Overflow[^]
:)
 
Share this answer
 
Comments
Patrice T 1-May-20 15:22pm    
5
BillWoodruff 1-May-20 17:12pm    
+5
The good old Ace 12 provider can be quite temperamental for installation...

Usually the problem is with trying to use this is related to 32 & 64 bit applications:
1. If the application using it is 64 bit, then you need to have the 64 bit version.
2. When you access it via various IDEs (Visual Studio, SSMS) you need the 32 bit version.
3. If this is a website; then the server (eg IIS) must be set accordingly (IIS: App Pool)

References:
Pinal Dave- Export Error - 'Microsoft.ACE.OLEDB.12.0' provider is not registered...[^]
Connection Strings- The 'Microsoft.ACE.OLEDB.12.0' provider is not registered...[^]
Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine[^]
 
Share this answer
 
Comments
BillWoodruff 1-May-20 17:12pm    
+5
MadMyche 1-May-20 17:35pm    
Thank you

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900