October 28, 2020 at 2:04 am
In the list of connection manager driver, I cannot find MSOLEDBSQL,
There is a microsoft OLEDB for SQL server, but that is SQLOLEDB, as the online doc says both SQLOLEDB and SQLNCLI native client will be deprecated. For new development use MSOLEDBSQL, but I cannot that driver in the list when I create new connection manager.
What do I miss?
Thanks
October 28, 2020 at 2:23 am
google is your friend. A simple search landed this url:
October 28, 2020 at 3:50 am
I did google before I posted and found the page too.
But that is not the answer. Microsoft said those two are deprecated, new development should use the new one. But why the old ones are in the default connection manager lists, the new one-MSOLEDBSQL is not on the connection manager driver list even in the newest VS integration service project tool . And we have to download?
That does not make sense
October 28, 2020 at 12:52 pm
Have you installed Visual Studio and SSDT?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 28, 2020 at 5:35 pm
another try I got MSSQLOLEDB.1 instead of SQLOLEDB.1 in the conneciton string.
THanks all
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply