README Execute stored procedure (using ODBC CALL syntax) and process return codes and output parameters (OLE DB)

Updated: 17 July 2006

This example shows processing a rowset, a return code, and an output parameter. This sample is not supported on IA64.

This sample uses Transact-SQL and Visual C++.

Before running this sample, make sure the following software is installed:

  • This sample connects to your computer's default SQL Server instance. To connect to a named instance, change the connection string from L"(local)" to L"(local)\name", where name is the named instance. By default, SQL Server Express installs to a named instance.
  • The sample requires you to execute the following stored procedure, which you can find in the sample's scripts directory:
    USE AdventureWorks
    DROP PROCEDURE myProc
    GO
    
    CREATE PROCEDURE myProc 
        @inparam nvarchar(5),
        @outparam int OUTPUT
    
    AS
    SELECT Color, ListPrice 
    FROM Production.Product WHERE Size > @inparam
    SELECT @outparam = 100
    
    IF  (@outparam > 0)
        RETURN 999
    ELSE
        RETURN 888
    GO
    
    In SQL Server Management Studio, load and execute the Scripts\setup.sql script or execute the following command in a Command Prompt window:
    sqlcmd -E -I -i Scripts\setup.sql
    
  • If you are using Visual Studio, load the InitializeAndEstablishConnection_A.sln file and build it.
  • If you are using MSBuild.exe, invoke MSBuild.exe at a command prompt, passing it the InitializeAndEstablishConnection_A.sln file:
    MSBuild InitializeAndEstablishConnection_A.sln
    

  • From Visual Studio, invoke Start Without Debugging (CTRL+F5).
  • If you built with MSBuild.exe, invoke InitializeAndEstablishConnection_A.exe.

Change History

Release History

17 July 2006

Changed content:
  • Clarified and updated prerequisites including the Web site for downloading the samples.
New content:
  • Added information on connecting to a named instance.

Community Additions

ADD
Show: