SQL query fails for Access 2016 x64 redistributable

Geetha 1 Reputation point
2021-01-12T04:45:17.53+00:00

Hi All,

We have upgraded from access 2010 x64 redistributable to 2016 x64 distributable. After installing 2016 redistributable, SQL query execution fails for access db. It works when SQL Native client 2012 is installed.

However as native client is deprecated, we are looking for other alternatives to work with access db 2016 redistributable.

We have tried with "Microsoft OLE DB Driver for SQL Server" installed but query execution fails.

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,971 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,005 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,306 Reputation points Microsoft Vendor
    2021-01-13T07:00:07.387+00:00

    Hi @Geetha ,

    If you have installed Microsoft Access Database Engine 2016, I guess that you still need to set the Provider argument of the ConnectionString property.

    1.If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”

    2.If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”

    3.If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”

    Please refer to install instructions of Microsoft Access Database Engine 2016 Redistributable to get detail information.

    Best regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.


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.