sql server – SQLNCLI is Deprecated, but is that only for SQLNCLI OLEDB, or for SQLNCLI ODBC as well?

sql server – SQLNCLI is Deprecated, but is that only for SQLNCLI OLEDB, or for SQLNCLI ODBC as well?

if you are using SQLNCLI ODBC (and not SQLNCLI OLEDB), it seems that is not actually deprecated

It is deprecated, but still supported some versions. When the SQL Server OleDB Provider in SQLNCLI was deprecated, the packaging of the ODBC driver changed, and the code ported to the ODBC Driver For SQL Server.

The OleDb provider was later un-deprecated and a new one was produced. But thats another story.

So essentially with SNAC ODBC youre just on an older version of the ODBC driver, and you should upgrade to a newer version at some point.

sql server – SQLNCLI is Deprecated, but is that only for SQLNCLI OLEDB, or for SQLNCLI ODBC as well?

Leave a Reply

Your email address will not be published.