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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,998 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 45,106 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 37,671 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.