%3CLINGO-SUB%20id%3D%22lingo-sub-1949772%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-1949772%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CP%3EOLE%20DB%20Driver%2018.5%20for%20SQL%20Server%20is%20released%2C%20bringing%20support%20for%20SQL%20Data%20Discovery%20and%20Classification%20and%20Azure%20Active%20Directory%20Service%20Principal%20authentication%20to%20the%20driver%20along%20with%20a%20number%20of%20fixes.%20The%26nbsp%3Bdriver%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%22%3Edownloaded%20directly%20from%20Microsoft%3C%2FA%3E.%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChanges%3A%3C%2FP%3E%3CUL%3E%3CLI%3EAdded%20support%20for%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Frelational-databases%2Fsecurity%2Fsql-data-discovery-and-classification%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Data%20Discovery%20and%20Classification%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fconnect%2Foledb%2Ffeatures%2Fusing-azure-active-directory%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3EAzure%20Active%20Directory%20Service%20Principal%20authentication%20support%3C%2FSPAN%3E%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EFixed%3A%3C%2FP%3E%3CTABLE%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CSTRONG%3EIssue%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3EDetails%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFixed%20an%20issue%20with%20embedded%20NUL%20characters.%3C%2FTD%3E%3CTD%3EFixed%20a%20bug%2C%20which%20resulted%20in%20the%20driver%20returning%20an%20incorrect%20length%20of%20strings%20with%20embedded%20NUL%20characters.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFixed%20a%20memory%20leak%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fconnect%2Foledb%2Fole-db-interfaces%2Fibcpsession-ole-db%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EIBCPSession%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Einterface.%3C%2FTD%3E%3CTD%3EFixed%20a%20memory%20leak%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fconnect%2Foledb%2Fole-db-interfaces%2Fibcpsession-ole-db%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EIBCPSession%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Einterface%20involving%20bulk%20copy%20operations%20of%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Esql_variant%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Edata%20type.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFixed%20bugs%2C%20which%20resulted%20in%20incorrect%20values%20being%20returned%20for%20SSPROP_INTEGRATEDAUTHENTICATIONMETHOD%20and%20SSPROP_MUTUALLYAUTHENTICATED%20properties.%3C%2FTD%3E%3CTD%3EPrevious%20versions%20of%20the%20driver%20returned%20truncated%20values%20of%20the%20SSPROP_INTEGRATEDAUTHENTICATIONMETHOD%20property.%20Also%2C%20in%20the%20ActiveDirectoryIntegrated%20authentication%20case%2C%20the%20returned%20value%20of%20the%20SSPROP_MUTUALLYAUTHENTICATED%20property%20was%20VARIANT_FALSE%20even%20when%20both%20sides%20were%20mutually%20authenticated.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFixed%20a%20linked%20server%20remote%20table%20insert%20bug.%3C%2FTD%3E%3CTD%3EFixed%20a%20bug%20which%20caused%20a%20linked%20server%20remote%20table%20insert%20to%20fail%20if%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdatabase-engine%2Fconfigure-windows%2Fconfigure-the-user-options-server-configuration-option%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ENOCOUNT%20server%20configuration%20option%3C%2FA%3E%20has%20been%20enabled.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFixed%20the%20SSPROP_INIT_PACKETSIZE%20property%20default%20value%20handling%3C%2FTD%3E%3CTD%3EFixed%20an%20unexpected%20error%20when%20the%20SSPROP_INIT_PACKETSIZE%20property%20was%20set%20to%20its%20default%20value%20of%200.%20For%20details%20about%20this%20property%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fconnect%2Foledb%2Fole-db-data-source-objects%2Finitialization-and-authorization-properties%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EInitialization%20and%20Authorization%20Properties%3C%2FA%3E.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFixed%20buffer%20overflow%20issues%20in%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fconnect%2Foledb%2Fole-db-interfaces%2Fibcpsession-ole-db%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EIBCPSession%3C%2FA%3E%3C%2FTD%3E%3CTD%3EFixed%20buffer%20overflow%20issues%20when%20using%20malformed%20data%20files.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFixed%20accessibility%20issues%3C%2FTD%3E%3CTD%3EFixed%20accessibility%20issues%20in%20the%20installer%20UI%20and%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fconnect%2Foledb%2Fhelp-topics%2Fsql-server-login-dialog%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%20Login%20dialog%3C%2FA%3E%20(reading%20content%2C%20tab%20stops).%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%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%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-1949772%22%20slang%3D%22en-US%22%3E%3CP%3EOLE%20DB%20Driver%2018.5%20for%20SQL%20Server%20is%20released%2C%20bringing%20support%20for%20SQL%20Data%20Discovery%20and%20Classification%20and%20Azure%20Active%20Directory%20Service%20Principal%20authentication.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1949772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

OLE DB Driver 18.5 for SQL Server is released, bringing support for SQL Data Discovery and Classification and Azure Active Directory Service Principal authentication to the driver along with a number of fixes. The driver can be downloaded directly from Microsoft.

 

Changes:

Fixed:

IssueDetails
Fixed an issue with embedded NUL characters.Fixed a bug, which resulted in the driver returning an incorrect length of strings with embedded NUL characters.
Fixed a memory leak in the IBCPSession interface.Fixed a memory leak in the IBCPSession interface involving bulk copy operations of sql_variant data type.
Fixed bugs, which resulted in incorrect values being returned for SSPROP_INTEGRATEDAUTHENTICATIONMETHOD and SSPROP_MUTUALLYAUTHENTICATED properties.Previous versions of the driver returned truncated values of the SSPROP_INTEGRATEDAUTHENTICATIONMETHOD property. Also, in the ActiveDirectoryIntegrated authentication case, the returned value of the SSPROP_MUTUALLYAUTHENTICATED property was VARIANT_FALSE even when both sides were mutually authenticated.
Fixed a linked server remote table insert bug.Fixed a bug which caused a linked server remote table insert to fail if the NOCOUNT server configuration option has been enabled.
Fixed the SSPROP_INIT_PACKETSIZE property default value handlingFixed an unexpected error when the SSPROP_INIT_PACKETSIZE property was set to its default value of 0. For details about this property, see Initialization and Authorization Properties.
Fixed buffer overflow issues in IBCPSessionFixed buffer overflow issues when using malformed data files.
Fixed accessibility issuesFixed accessibility issues in the installer UI and the SQL Server Login dialog (reading content, tab stops).
 
The updated driver can be downloaded directly from Microsoft.

David Engel