You must Sign In to post a response.
  • Category: .NET

    How to registered in this version

    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
    The error refers your system doesn't have an access DB related files. Install the connectivity drivers from the below URL,

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

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

  • #769699
    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.

    B.Ramana Reddy

  • #769803
    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

  • Sign In to post your comments