The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Last Reply on Oct 05, 2015 01:32 AM By Andrea

Posted on Oct 05, 2015 01:32 AM

Hi All,

I am using excel upload and save in db operation, its working perfectly in local but in server it throwing the following error,

System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at PWWeb.ER.Uploads.policyupload.InsertExcelRecords()


So that i have intalled Microsoft access engine, afterthat also it is returning the same error,Please provide if any other solution, 64 bit system server

Posted on Oct 05, 2015 01:32 AM
Hi @bebins,
Please try the following

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.

It might help you.

Cheers Andrea.
I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html