Forum Discussion
OLE DB Driver for SQL Server Azure Connection Problem
I'm using V18.3 of the Microsoft OLE DB Driver for SQL Server to connect to an Azure SQL Server Managed Instance and it has worked perfectly. The connection string uses Active Directory Integrated A...
OP here. I think I found the explanation, but not the solution for why the OLE DB Driver for SQL Server fails to connect with 'DataTypeCompatibility=80' but connects without it. See the 'Note' in the first purple box on this page:
https://tinyurl.com/yajwn4hd
I don't know enough about Azure to know if there is a workaround or setting for AD Authentication which would let me use the Xml field type with my ADO / OLE DB application.
Any suggestions welcomed.