Category: .NET

04 Dec 2017 11:53

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	4

How to registered in this version

Hi
In my code excel ole.db connection string

this is my code

connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";

but i meet this issue this is error

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

I have also installed corresponding provider exe in my pc but this issue not fixed

any one guide me how to fix this?

#769546

22 Mar 2018 12:36

Joined:	30/07/2009
Level:	Gold
Points:	3389

Points:	2

The error refers your system doesn't have an access DB related files. Install the connectivity drivers from the below URL,

https://www.microsoft.com/en-us/download/details.aspx?id=23734

After installing this, please verify the same it must work.

Regards,
V.M. Damodharan
"Your talent will be worthless, when you have fear and tension."

#769699

07 Aug 2018 16:03

Joined:	28/09/2005
Level:	Gold
Points:	637

Points:	3

This might cause because you have installed either one of the 32-bit version and default, IIS will be on 64-bit operating system will run applications in a 64-bit worker process. 64-bit processes cannot load 32-bit DLLs. When a call is made to the ACE provider, the 64 bit process will attempt to locate a 64-bit DLL. If it doesn't exist, you get the error message.

try to change the application pool advance settings Enable 32-bit Applications to true in IIS.

Hope this works.

Thanks!
B.Ramana Reddy

#769803

21 Nov 2018 14:26

Joined:	21/11/2018
Level:	Bronze
Points:	0

Points:	2

Here's a discussion about this error, please refer to it and let me know whether it is worked for you.

HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' the provider is not registered on the local machine"

Best Regards

How to registered in this version

Email subscription

About dotnetspider.com

Quick Links

General

Services