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
- Build the Xp_dblib.dll.
- Place the compiled Xp_dblib.dll in the Microsoft SQL Server\80\Tools\Binn directory.
- Start the server.
- Start SQL Query Analyzer, and then run the Xp_dblib.sql script.