![]() ![]() Microsoft has decided to undeprecate (a new word) OLE DB and released a new OLE DB provider, Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). The OLE DB story continues to evolve and I hope we see a roadmap and guidance from Microsoft soon. However, I still think it’s prudent to use the stand-alone ODBC driver instead of OLE DB for new native applications. The above warning was removed from the SQL Server documentation shortly after this article was first published. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database. Avoid using SNAC in new development work, and plan to modify applications that currently use it. ![]() SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. I hope the warning excerpt below from the SQL Server Books Online is not a surprise to you (emphasis mine):
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |