Updated: November 23, 2015

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.

SQLFreeStmt is not recommended in ODBC 3.0 and later. However if the application needs to reuse the statement you should still use SQLFreeStmt with the SQL_RESET_PARAMS and SQL_UNBIND options). You might also use SQLCloseCursor, SQLBindParameter, SQLBindCol, SQLSetDescField, and SQLFreeHandle to replace or duplicate the function of SQLFreeStmt and should use them instead.

In general, it is more efficient to reuse statements than to drop them and allocate new ones. However in some situations, like the reusing of statements, SQLFreeStmt still must be used.

SQLFreeStmt Function
ODBC API Implementation Details

Community Additions