Microsoft KB Archive/233192

{|
 * width="100%"|

INF: xp_param Sample Requires SQL 7.0 Srv.h File to Compile on SQL 7.0

 * }

Q233192

-

The information in this article applies to:


 * Microsoft SQL Server version 7.0
 * Microsoft SQL Server 2000 (all editions)

-

SUMMARY
When a customer tries to compile the xp_param sample in SQL Server 7.0, they may get the following errors:

"... warning C4013: 'srv_paraminfo' undefined: assuming extern returning int:"

-or-

"xp_param.obj: error LNK2001: unresolved external symbol _srv_paraminfo"

These errors occur if the customer is using the wrong SRV.h header file.

MORE INFORMATION
The version of the file for SQL 7.0 is different from the SQL 6.5 version, and the SQL 7.0 version is needed to compile the xp_param sample correctly. Many times this error occurs if there is more than one version of the file on the computer, and the wrong version is picked up by the compiler before the current version. You can easily check this by typing the SET command at a DOS prompt to see what the order of the various "include" and "lib" directory paths are. To fix the problem, specify the current path to the MSSQL7 include directory to load first.

The xp will compile correctly at that point.

On a typical SQL Server 7.0 computer, the path for the include directory will be:

  C:\mssql7\devtools\include Additional query words:

Keywords : kbSQLServ700 kbSQLServ2000

Issue type : kbinfo

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ700 kbSQLServ2000Search kbSQLServ2000