Smartptr (C++) (SQL-DMO)

The Smartptr sample illustrates using specific Microsoft® Visual C++® COM development features to reduce program source size and speed development. The sample shows:

• Using the #import directive to create smart pointers from the localized SQL-DMO type library.
• Creating an instance of a SQLServer object.
• Using smart pointers to manipulate SQLServer and QueryResults object properties and methods, including:
  • Setting SQLServer object properties such as LoginTimeout and NetPacketSize.
  • Calling the SQLServer object methods Connect and Close.
  • Calling the ExecuteWithResults method to execute a Transact-SQL command batch and capture results.
  • Setting and getting QueryResults object properties such as CurrentResultSet and Columns.
  • Displaying result set members by using the QueryResults object GetColumnString method.
• Error handling in a C++ application using smart pointers.

The Smartptr sample is a console application.

Smartptr requires Visual C++ 5.0 or later. Project files for Visual C++ (.dsp and .dsw extensions) are included. In the project files, build configurations are defined for computers using Intel or compatible processors. All configurations create a multibyte character application.

Functions Illustrated

CoCreateInstance; Release

Objects, Methods, and Properties Illustrated

Err; Err.Description; Err.Error; Err.ErrorMessage; Err.Source; QueryResults; QueryResults.ColumnName; QueryResults.Columns; QueryResults.CurrentResultSet;. QueryResults.GetColumnString; QueryResults.ResultSets; QueryResults.Rows; SQLServer; SQLServer.ApplicationName; spSQLServer.Close; SQLServer.Connect; SQLServer.ExecuteWithResults; SQLServer.HostName; SQLServer.LoginTimeout; SQLServer.NetPacketSize