How are you supporting MS OLEDB driver?SDAC 8.0.5 is compatible with Microsoft OLE DB Driver 18 for SQL Server
In SDAC TMSConnection I cannot choose a provider that correspondents with this provider. Only prNativeClient. NativeClientVersion goes up to 2012.
I have installed the new Microsoft OLE DB Driver for SQL Server (https://blogs.msdn.microsoft.com/sqlnat ... ql-server/) and removed the (old) SQL Native Client.
When I use Provider = prAuto a connection is made that uses the prSQL setting and not anything that resembles MS OLEDB driver.
According to MS Documentation you should use Provider=MSOLEDBSQL. When I enter this into the connection string the string cannot be parsed bij TMSConnection.
How do I get SDAC to use the Microsoft OLE DB Driver for SQL Server?