From an , navigate to the folder containing the .msi file. Then, run the following command:
| Feature | Description | Available In | |---|---|---| | | Supports password-based, integrated, and access token-based authentication with Microsoft Entra ID (formerly Azure AD) | 18.2.1 | | Federated Identity Support | Enables connections to Azure SQL Database using federated identities | 18.2.1 | | SQL Data Discovery and Classification | Provides ability to work with classified data columns | 18.5 | | Always Encrypted | Supports Always Encrypted for protecting sensitive data | 18.x | | TLS 1.2 Support | Ensures secure, modern encrypted connections | 18.x | | Multiple Active Result Sets (MARS) | Allows multiple active result sets over a single connection | 18.x | | User-Defined Types (UDT) | Supports SQL Server user-defined data types | 18.x | | Snapshot Isolation | Provides support for snapshot isolation levels | 18.x | | XML Data Type Support | Enables working with XML data type columns | 18.x | download microsoft ole db driver for sql server 18
The official, most reliable source to download the driver is directly from Microsoft. You can find the latest 18.x releases by visiting the . Download Options (18.x Series) From an , navigate to the folder containing the
Provider=MSOLEDBSQL;Data Source=yourServer.database.windows.net;Initial Catalog=DatabaseName;Authentication=ActiveDirectoryAccessToken;AccessToken=your_token_here;Encrypt=yes; Download Options (18