%3CLINGO-SUB%20id%3D%22lingo-sub-916316%22%20slang%3D%22en-US%22%3EReleased%3A%20Update%20to%20Microsoft%20OLE%20DB%20Driver%2018%20for%20SQL%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-916316%22%20slang%3D%22en-US%22%3E%3CDIV%3EOLE%20DB%20Driver%2018.3%20for%20SQL%20Server%20was%20released%20this%20week%2C%20bringing%20additional%20Azure%20Active%20Directory%20authentication%20methods%20directly%20into%20the%20driver.%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH4%20id%3D%22toc-hId-1458460418%22%20id%3D%22toc-hId-1458460418%22%3EChanges%3A%3C%2FH4%3E%3CUL%3E%3CLI%3EAdded%20support%20for%20additional%20Azure%20Active%20Directory%20authentication%20methods%3A%20ActiveDirectoryInteractive%20and%20ActiveDirectoryMSI%20(See%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fconnect%2Foledb%2Ffeatures%2Fusing-azure-active-directory%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EUsing%20Azure%20Active%20Directory%3C%2FA%3E)%3CBR%20%2F%3ENote%3A%20ActiveDirectoryInteractive%20supports%20Multi%20Factor%20Authentication%20(MFA)%20flows.%3C%2FLI%3E%3CLI%3EEmbedded%20Active%20Directory%20Authentication%20Library%20(ADAL).%26nbsp%3B%3CSPAN%3EA%20separate%20installation%20of%20ADAL%20is%20no%20longer%20required%20to%20use%20certain%20authentication%20methods.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--897183038%22%20id%3D%22toc-hId--897183038%22%3EFixed%3A%3C%2FH3%3E%3CDIV%3E%3CUL%3E%3CLI%3E%3CSPAN%3EFixed%20drop%20index%20logic%20in%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3Flinkid%3D2106448%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EIIndexDefinition%3A%3ADropIndex%3C%2FA%3E%26nbsp%3B-%26nbsp%3B%3CSPAN%3EPrevious%20versions%20of%20the%20OLE%20DB%20driver%20can't%20drop%20a%20primary%20key%20index%20when%20the%20schema%20ID%20and%20the%20user%20ID%20of%20the%20owner%20of%20the%20index%20aren't%20equal.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3EThe%20updated%20driver%20can%20be%20%3CA%20title%3D%22download%20Microsoft%20OLE%20DB%20Driver%20for%20SQL%20Server%22%20href%3D%22https%3A%2F%2Faka.ms%2Fdownloadmsoledbsql%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Edownloaded%20directly%20from%20Microsoft%3C%2FA%3E.%3CBR%20%2F%3E%3CBR%20%2F%3EDavid%20Engel%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-916316%22%20slang%3D%22en-US%22%3E%3CP%3EOLE%20DB%20Driver%2018.3%20for%20SQL%20Server%20was%20released%20this%20week%2C%20bringing%20additional%20Azure%20Active%20Directory%20authentication%20methods%20directly%20into%20the%20driver.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-916316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member
OLE DB Driver 18.3 for SQL Server was released this week, bringing additional Azure Active Directory authentication methods directly into the driver.

 

Changes:

  • Added support for additional Azure Active Directory authentication methods: ActiveDirectoryInteractive and ActiveDirectoryMSI (See Using Azure Active Directory)
    Note: ActiveDirectoryInteractive supports Multi Factor Authentication (MFA) flows.
  • Embedded Active Directory Authentication Library (ADAL). A separate installation of ADAL is no longer required to use certain authentication methods.

Fixed:

  • Fixed drop index logic in IIndexDefinition::DropIndex - Previous versions of the OLE DB driver can't drop a primary key index when the schema ID and the user ID of the owner of the index aren't equal.
The updated driver can be downloaded directly from Microsoft.

David Engel