Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2025 (17.x) Preview
Azure SQL Managed Instance
This article describes how to change the SQL Server driver version for PolyBase.
When using sqlserver as a provider, PolyBase uses the Microsoft ODBC Driver for SQL Server installed with the product. Starting in SQL Server 2025 (17.x) Preview, two versions of the driver are installed: ODBC version 18 (the default), and ODBC version 17.
You should always use the latest driver. However, to ensure compatibility with previous editions, older ODBC versions can also be used.
For more information about which driver version supports which SQL Server version, see System requirements, installation, and driver files.
Change the version of the ODBC driver
To use Microsoft ODBC Driver version 17 with PolyBase, you must update the PolyBase ODBC Driver for SQL Server.ini file to specify which version of ODBC you want to use.
| Operating system | Location |
|---|---|
| Windows | <SQL Server installation Folder>\binn\PolyBase\ODBC Drivers |
| Linux | /var/opt/mssql/binn/Polybase/ODBC Drivers |
Change the following setup lines from:
Driver=PolyBase ODBC Driver for SQL Server\18.5.1.1\msodbcsql18.dll
Setup=PolyBase ODBC Driver for SQL Server\18.5.1.1\msodbcsql18.dll
To:
Driver=PolyBase ODBC Driver for SQL Server\17.10.6.1\msodbcsql17.dll
Setup=PolyBase ODBC Driver for SQL Server\17.10.6.1\msodbcsql17.dll
Restart SQL Server
After changing the INI file, you need to restart both PolyBase services:
- SQL Server PolyBase Data Movement
- SQL Server PolyBase Engine
On Linux, you can run the following command:
sudo systemctl restart mssql-server