creating extended stored procedure with Visual C++ 7 (vs 2003)

[AA]

Hello, I am trying and trying to create a XP for SQL 2000 but nothing works


I Start my Visual Studio, in the C++ Folder I select the "Extended Stored
Procedure" project. Then, a Wizard appear, I fill the xp name field with
"xp_test" value.

The VS generate all files. Then I compile the project, the compilation is
completed succesfully. Then I copy the DLL to the SQL2000 Binn directory,
Then I execute the "sp_addextendedproc" procedure, passing the name of the
method (xp_test) and the dll name "myxptest.dll"

The Dll is registred succesully, but when I execute it this error appear:

ODBC: Msg 0, Level 16, State 1
Cannot load the DLL myxptest.dll, or one of the DLLs it references. Reason:
126(error not found).

The Dll don't do anything strange, is just the example generated by the VS


Yestarday I downloaded a Regex Extended Stored Procedure (Source and
compiled dll) when I use the compiled dll that comes in the zip, everyting
works fine, but when I open the source, and compile in my VS 2003 the error
occur again.

Please, help me!!

Thanks

 

[Angel J. Hernández]

This might help you...

http://www.eggheadcafe.com/ng/microsoft.public.sqlserver.notificationsvcs/post218978.asp

Regards,

 

[Guest]

You should check the dependencies of your dll with the depends.exe tool
(located in the \Common7\Tools\Bin folder of the VS.net installation folder).
My bet is that it will work if you copy the dlls "msvcr71.dll" and
"msvcr71d.dll" to the binn directory together with your extended sproc dll.

HTH, Jakob.