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

    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
    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
    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


  • Sign In to post your comments