Using xp_gettable_dblib

Extended Stored Procedure Programming

Extended Stored Procedure Programming

Using xp_gettable_dblib

This Microsoft® Visual C++® sample shows using the DB-Library interface to open a bound connection to the same instance of Microsoft SQL Server™ that called the extended stored procedure. The server returns a result set to the extended stored procedure, which passes the result set to the client.

Default Location

x:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\ODS\Xp_dblib

Running the Sample

To create the extended stored procedure DLLs for these samples, go to the appropriate sample subdirectory and open the supplied .dsw file with Microsoft Visual C++.

To run this program

  1. Build the Xp_dblib.dll.

  2. Place the compiled Xp_dblib.dll in the Microsoft SQL Server\80\Tools\Binn directory.

  3. Start the server.

  4. Start SQL Query Analyzer, and then run the Xp_dblib.sql script.

See Also

Using Bound Connections

Samples