关于 扩展存储过程 的问题

[guostong]

调试 sqlserver 2000 的例子 ： Xp_param

xp_param.c
error C2065: 'ODS_VERSION' : undeclared identifier
error C2065: 'srv_paraminfo' : undeclared identifier

环境 ： vs6.0 + sp5 + sdk + sqlserver 2000

[gmlxf]

Using xp_srv_paraminfo_sample
This Microsoft® Visual C++® sample shows how to analyze parameters from an extended stored procedure call, and post a result set to the client about each parameter and parameter value.

Default Location
x:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\ODS\Xp_param

Running the Sample
To create the extended stored procedure DLLs for these samples, in the appropriate sample subdirectory, open the supplied .dsw file in Microsoft Visual C++.

To run this program

1、Build the Xp_param.dll.

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

3、Start the server.

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

[CrazyFor]

好久不见思归大侠了.:)

[softye]

帮你UP

[gmlxf]

这么晚了，人都很少了，等明天吧
我也不会，帮你up下。

[saucer]

you need to use the include files and libraries that comes with SQL Server 2000 instead of the ones that came with VC6.0. You might need to install the development tool from SQL Server 2000 CD. Add the proper include path to C:\Program Files\Micosoft SQL Server 2000\80\Tools\DevTools\include

Also see

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odssql/ods_6_con_01_22sz.asp

http://support.microsoft.com/default.aspx?kbid=205415