C#•13mo ago

Issues when attempting to use.Net 8 to connect to an Access database

Hello folks, Do some of you know how to connect a .NET 8 application with an Access database .accdb?
I use this code, but I'm receiving this error: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.."

PS-1: Yes, I'm in a Windows environment.
PS-2: Sorry I don't know where to post this.

 public void Connection() 
 {
     const string connectionString =
             "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "C:\\Users\\MICRO-52\\Desktop\\EoExperience\\PreRegistro.mdb;";

     
     const string insertSQL =
         "SELECT * FROM PreRegistro;";

     using (OleDbConnection connection = new OleDbConnection(connectionString))
     {
         OleDbCommand command = new OleDbCommand(insertSQL);

         command.Connection = connection;

         try
         {
             connection.Open();
             command.ExecuteNonQuery();
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.Message);
         }
     }
 }

 public void Connection() 
 {
     const string connectionString =
             "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "C:\\Users\\MICRO-52\\Desktop\\EoExperience\\PreRegistro.mdb;";

     
     const string insertSQL =
         "SELECT * FROM PreRegistro;";

     using (OleDbConnection connection = new OleDbConnection(connectionString))
     {
         OleDbCommand command = new OleDbCommand(insertSQL);

         command.Connection = connection;

         try
         {
             connection.Open();
             command.ExecuteNonQuery();
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.Message);
         }
     }
 }

 public void Connection() 
 {
     const string connectionString =
             "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "C:\\Users\\MICRO-52\\Desktop\\EoExperience\\PreRegistro.mdb;";

     
     const string insertSQL =
         "SELECT * FROM PreRegistro;";

     using (OleDbConnection connection = new OleDbConnection(connectionString))
     {
         OleDbCommand command = new OleDbCommand(insertSQL);

         command.Connection = connection;

         try
         {
             connection.Open();
             command.ExecuteNonQuery();
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.Message);
         }
     }
 }

 public void Connection() 
 {
     const string connectionString =
             "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "C:\\Users\\MICRO-52\\Desktop\\EoExperience\\PreRegistro.mdb;";

     
     const string insertSQL =
         "SELECT * FROM PreRegistro;";

     using (OleDbConnection connection = new OleDbConnection(connectionString))
     {
         OleDbCommand command = new OleDbCommand(insertSQL);

         command.Connection = connection;

         try
         {
             connection.Open();
             command.ExecuteNonQuery();
         }
         catch (Exception ex)
         {
             Console.WriteLine(ex.Message);
         }
     }
 }

JorramOP•12/4/24, 8:19 PM

@Angius it's possible, right.... right?

Angius•12/4/24, 8:19 PM

I mean, probably

Angius•12/4/24, 8:20 PM

Also, did you, like, google the error?

Angius•12/4/24, 8:20 PM

'Cause I'm getting a lot of results

Angius•12/4/24, 8:20 PM

Like, a lot

Angius•12/4/24, 8:20 PM

All of them point to MS Access Redistributable 2010 needing to be installed

Angius•12/4/24, 8:21 PM

https://duckduckgo.com/?q=The+%27Microsoft.ACE.OLEDB.12.0%27+provider+is+not+registered+on+the+local+machine

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the lo...

DuckDuckGo. Privacy, Simplified.

JorramOP•12/4/24, 8:22 PM

I mean... they usually tell you to download Access Database Runtime, but I already did that, but the issue persists.

Angius•12/4/24, 8:23 PM

2010?

JorramOP•12/4/24, 8:24 PM

Ok... I don't know if I installed the 2010 version specifically...

JorramOP•12/4/24, 8:25 PM

Nop I downloaded the 2016 version... Mb

Angius•12/4/24, 8:26 PM

Yeah, six years too new for this project lmao

Issues when attempting to use.Net 8 to connect to an Access database

Similar Threads

Similar Threads

Similar Threads