Smartptr

SQL-DMO

SQL-DMO

Smartptr

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

Default Location

C:\Program Files\
Microsoft SQL Server\80\Tools\Devtools\Samples\sqldmo\cpp\Smartptr

Running the Sample
  1. Open the Smartptr.dsw workspace.

  2. Run the application.
Remarks

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.

Objects, Methods, and Properties Illustrated
CoCreateInstance QueryResults.ResultSets
Err QueryResults.Rows
Err.Description Release
Err.Error spSQLServer.Close
Err.ErrorMessage SQLServer
Err.Source SQLServer.ApplicationName
QueryResults SQLServer.Connect
QueryResults.ColumnName SQLServer.ExecuteWithResults
QueryResults.Columns SQLServer.HostName
QueryResults.CurrentResultSet SQLServer.LoginTimeout
QueryResults.GetColumnString SQLServer.NetPacketSize

See Also

SQL-DMO Samples