Data Types (OLE DB)


System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

In order to execute Transact-SQL statements and process the results using the SQL Server Native Client OLE DB provider, you must know how the SQL Server Native Client OLE DB provider maps SQL Server data types to OLE DB data types when binding parameters or columns in a rowset, and when it uses the ITableDefinition interface to create a table in SQL Server.

SQL Server Native Client (OLE DB)

Community Additions