como solucionar esto ; El proveedor 'Microsoft.ACE.OLEDB.12.0' no está registrado en el equipo local. (System.Data) en li laptop de 64

edwin zaravia 0 Reputation points
2024-10-04T04:29:15.1633333+00:00

sql imagen

SQL Server | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,441 Reputation points
    2024-10-04T04:45:06.0333333+00:00

    This is an English spoken forum.

    As the error message says:

    If you want to use a specific data provider like here ACE, you have to install it first.

    And by the version number "12" of ACE it seems you are using an very old SSMS version.

    Install/update all =>

    Microsoft Access Database Engine 2016 Redistributable

    Download SQL Server Management Studio (SSMS)

    0 comments No comments

  2. ZoeHui-MSFT 41,491 Reputation points
    2024-10-07T06:05:45.3133333+00:00

    Hi @edwin zaravia,

    You may need to install the Microsoft Access Database Engine 2016 Redistributable

    In case of the 32-bit and the 64-bit issue, you may follow the blog to install the two version together.

    Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

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.