September 23, 2003 at 3:53 am
Hi All,
I found an article on the extended stored proc xp_file. Downloaded the project files and tried to build the DLL using VC++ tool in Microsoft Visual Studio. However, it is coming up with compiling errors. Please note that I never used VC++ before.
I am pasting the errors below and appreciate any help in this matter....
Errors:
--------------------------------------------
----Configuration: XP_FILE - Win32 Debug-----Compiling...
proc.cpp
C:\xp_file\proc.cpp(184) : error C2065: 'srv_paraminfo' : undeclared identifier
C:\xp_file\proc.cpp(189) : error C2065: 'SRVBIGVARCHAR' : undeclared identifier
C:\xp_file\proc.cpp(189) : error C2065: 'SRVBIGCHAR' : undeclared identifier
C:\xp_file\proc.cpp(289) : error C2065: 'srv_paramsetoutput' : undeclared identifier
Error executing cl.exe.
proc.obj - 4 error(s), 0 warning(s)
--------------------------------------------
Cheers....
Phani
September 23, 2003 at 7:07 am
The error is due to wrong or out of date include files. Replace srv.h, srvapi.h, srvconst.h, srvdbtyp.h, srvmisc.h, srvstruc.h, srvtok.h, srvtypes.h in your C++ include folder (making a copy first) with the ones in MSSQL7\DevTools\Include.
Also you will need to add MSSQL7\DevTools\Lib to additional library path in
Project Settings, Link Tab (changing category to Input).
You should then find it will compile OK.
Edited by - davidburrows on 09/23/2003 07:07:56 AM
Far away is close at hand in the images of elsewhere.
Anon.
September 23, 2003 at 9:01 am
Hi David,
I am using SQLServer2000 and therefore bit confused about the location of include files you mentioned.
Could you please give some more information?
Ta,
Phani
September 23, 2003 at 9:13 am
Sorry about that, I realized that a few minutes ago. I haven't got SQL2K so I don't know. I suggest you look on the server to locate where sql was installed.
Far away is close at hand in the images of elsewhere.
Anon.
September 24, 2003 at 2:01 am
Hi David,
It worked and I am using xp_file now.
Thank you very much for your help.
Cheers....
Phani
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply