Edit

ICommand (Native Client OLE DB Provider)

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Important

The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). Both the SQL Server Native Client OLE DB provider (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new development. Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server going forward.

This topic discusses OLE DB behavior that is specific to SQL Server Native Client.

ICommand::Execute

Inserting data that is greater than the size of a column typically results in an error. However, there are situations where S_OK will be returned but the dwStatus will be set to DBSTATUS_S_TRUNCATED. This generally occurs when inserting data with parameters, where the column is not large enough to hold the data, and ICommandWithParameters::SetParameterInfo has not been called.

See Also

Interfaces (OLE DB)