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

bebins
 
on Oct 05, 2015 01:32 AM
7689 Views

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

Download FREE API for Word, Excel and PDF in ASP.Net: Download
Andrea
 
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.