Microsoft.ACE.OLEDB.12.0 provider is not registred problem still nog fixed

Eric Klein Goldewijk 20 Reputation points
2023-05-08T15:04:52.17+00:00

I have build a solution in SSIS (Visual Studio 2019) that takes data from an Excel file and upload it in a SQL server table (Microsoft SQL Server 2019).

When I execute the solution, every thing goes fine.

But when I deploy the solution to SQL and excecute the solution within a Job, I get the Microsoft.ACE.OLEDB.12.0 provider is not registred.

I have installed and re-installed both Microsoft Access Databse Engine 2010 Redistributalbe and Microsoft Access Database Engine 2016 Redistributable. I have toggeld the Run64BitRuntime and checked the TargetServerVersion....nothing seems to work.

I have no idea what to do next?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
SQL Server | Other
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 41,496 Reputation points
    2023-05-09T01:31:52.2166667+00:00

    Hi @Eric Klein Goldewijk

    Microsoft.ACE.OLEDB.12.0 provider is not registered

    From the error message, it seems to be a 32bit vs 64bit issue.

    Check installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing, you may install both 32bit and 64bit provider.

    Microsoft Access Database Engine 2010 Redistributable

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Eric Klein Goldewijk 20 Reputation points
    2023-05-10T08:51:38.8433333+00:00

    I have installed the AccesDataBaseEngine, both 12 and 16, I can see them in the registry. But it is still not working....

    Are there anymore options?

    Regards,

    Eric

    User's image


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.