Support for Microsoft OLE DB Driver for SQL Server?
Posted: Wed 15 Aug 2018 10:19
In viewtopic.php?t=37061 you state that
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?
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?