local Msaccess database file is not connecting with Oledb and Odbc

prasanna p

Hi Friends,

I am not able to connect to local system Msaccess database with .mdb file with Oledb and Odbc connection.

The database have password.I tried with different solution but getting system.data.oledb is not supported on this platform error.

string connectionString = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\DB_BKUP\RESTSALES.mdb;Jet OLEDB:Database Password=Touchpoint;");
conn.Open();

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
try
{
connection.Open();

// Execute database operations using OleDbCommand
// For example, select data from a table
string query = "SELECT * FROM TRANSACTIONDETAILS";
using (OleDbCommand command = new OleDbCommand(query, connection))
{
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
// Access data using reader
Console.WriteLine(reader["ColumnName"].ToString());
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error: " + ex.Message);
}
}

Please tell me how to connect to the local access db file from windows forms or WPF application

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anil Sharma2y ago
One of the Reason is System.Data.OleDb is not supported in .NET Core
prasanna p2y ago
hi Jayraj, I followed all the steps, getting same error System.Data.OleDb is not supported on this platform
Jayraj Chhaya2y ago
Hi prasanna p,

To connect to a local Access database (.mdb file) from a Windows Forms or WPF application using OLEDB or ODBC, you need to ensure that you have the necessary drivers installed on your system.

If you are encountering the "System.Data.OleDb is not supported on this platform" error, it could be due to missing or incompatible drivers. Here are a few steps you can follow to resolve this issue:
1. Install the Microsoft Access Database Engine:
  
  Download and install the appropriate version of the Microsoft Access Database Engine from the official Microsoft website. Make sure to choose the version that matches your system architecture (32-bit or 64-bit) and the version of Microsoft Office installed on your machine.
2. Update your connection string:
  
  Modify your connection string to use the correct provider and driver. For OLEDB, use the following connection string format:
  
  string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Path\To\Your\Database.mdb;Jet OLEDB:Database Password=YourPassword;";
3. Check the target platform of your application:
  
  Ensure that your application is targeting the correct platform (x86 or x64) that matches the installed drivers. You can check this in the project properties under the Build tab.
4. Verify the reference to System.Data.OleDb:
  
  Make sure that your project has a reference to the System.Data.OleDb assembly. You can check this in the References section of your project.
5. Once you have followed these steps, you should be able to connect to your local Access database using OLEDB or ODBC in your Windows Forms or WPF application.
  
  Please note that the code snippet you provided uses both OLEDB and ODBC connections. It is recommended to choose one connection type (either OLEDB or ODBC) and modify your code accordingly.