ASP.NET

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

8 replies

Last post May 26, 2011 10:06 PM by rajesh_gupta1

‹ Previous Thread|Next Thread ›

vishal.kedar

Member

165 Points

65 Posts

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

Nov 14, 2008 08:32 AM|LINK

Server Error in '/' Application.

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Source Error:

Line 485:                OleDbDataAdapter mydata = new OleDbDataAdapter("select * from [Sheet1$]", strconn);

Line 486:                mydata.TableMappings.Add("Table", "ExcelTest");
Line 487:                mydata.Fill(ds);
Line 488:
Line 489:                StringBuilder strb = new StringBuilder();

Source File: c:\inetpub\vhosts\smswonders.co.in\httpdocs\Users\Quick SMS.aspx.cs Line: 487

Stack Trace:

[InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.]
   System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) +975886
   System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +118
   System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53
   System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.OleDb.OleDbConnection.Open() +37
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
   Quick_SMS.btnSubmit_Click(Object sender, EventArgs e) in c:\inetpub\vhosts\smswonders.co.in\httpdocs\Users\Quick SMS.aspx.cs:487
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

strconn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0";

This connection I used.

plz help me.

thank you.

Moved by ecbruck on Nov 14, 2008 11:59 AM

- Reply
Wencui Qian ...

All-Star

56784 Points

5796 Posts

Microsoft

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

Nov 19, 2008 02:10 AM|LINK

Hi vishal.kedar,

The driver is valid when you've installed Microsoft Office 2007. So please check whether it has been installed first. If you haven't installed Microsoft Office 2007, you can try to save the database down to version 2003 and use Jet.OleDb.4.0 provider - assume you've installed Microsoft Office 2003.

Thanks.

Please mark the replies as answers if they help or unmark if not.

If you have any feedback about my replies, please contact msdnmg@microsoft.com

Microsoft One Code Framework
- Marked as answer by Wencui Qian - MSFT on Nov 21, 2008 09:15 AM
- Reply
Eric.Xu

None

0 Points

2 Posts

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

Oct 24, 2009 04:13 AM|LINK

Hi Wencui,

I had same problem on Office Access 2007. It can work on VS2008 . but fault on IIS7(vista) . I don't know why it is.

Thanks.

MOSS|BizTalk|BI|C#|Asp.net
- Reply
ckayun

Member

2 Points

1 Post

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

Jan 08, 2010 06:57 AM|LINK

I think you work under 64 bit OS.

Please change target platform before compilation to "x86" instead of "Any CPU"

in Visual Studio 2008, just go to menu ...

Build -> Configuration Manager -> Active Solution Platform: -> New -> Type or select the new platform -> x86 - > OK

Good luck.

Kayun
- Reply
kishec

Member

2 Points

1 Post

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

Aug 17, 2010 05:55 AM|LINK

Hi

I have website which will use OleDB.12.0 to read data from excelsheet.

But when hosted in production server it shows , "microsoft.ace.oledb.12.0 is not registered on the local mechine"

How can I correct this. FYI: in production server there is no MS Office. (Company policy does not allow to install MS office)

Please help

Regards

Kishor B
- Reply
bboyse

Member

2 Points

1 Post

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

Oct 17, 2010 04:58 AM|LINK

You need to change Compile configuration to x86, then Its Working.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machin
- Reply
arboundy

Member

2 Points

1 Post

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

Nov 08, 2010 08:25 AM|LINK

I went through this only the other day and wrote a post about it here http://www.arboundy.com/2010/11/the-microsoft.ace.oledb.12.0-provider-is-not-registered-on-the-local-machine/ - hope it helps!
- Reply
kprasanna

Member

2 Points

1 Post

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

Nov 16, 2010 04:44 PM|LINK

Hi

I am using 2010 Excel and 2003 Server which is 64 bit.

I am getting same error(first they had installed VS2008 then installed MS Office 2010). I tried to compile in X86 mode as well as install the following drives but no success.

AcceessDataBaseEngine.exe

AccessRuntime.exe

My error as same above "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine".

here is my string and calling VB.Net 2008:

MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; " & "data source='" & PrmPathExcelFile & " '; " & "Extended Properties='Excel 12.0 Xml;HDR=YES';")

'***I just try this also*** 'MyConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Password="""";User ID=Admin;Data Source=" & PrmPathExcelFile & ";Mode=Share Deny Write;Extended Properties=""HDR=YES;"";Jet OLEDB:Engine Type=37")

If anybody has any Idea, I appreciate your help.

Thanks,

KP

64 bit Excel application
- Reply
rajesh_gupta...

Member

6 Points

4 Posts

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

May 26, 2011 10:06 PM|LINK

In my case, I had the same issue. I figured out that this package was not installed on the server. Once installed, error went away.

Package: Microsoft office Access database engine 2007

You can download this package from Microsoft site

http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891

Hope it helps.

‹ Previous Thread|Next Thread ›

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

8 replies

vishal.kedar

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

Server Error in '/' Application.

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

Wencui Qian ...

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

Eric.Xu

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

ckayun

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

kishec

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

bboyse

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

arboundy

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

kprasanna

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

rajesh_gupta...

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

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft