I want to write an extended Stored Procedure in VB.net. I have searched the net pretty extensively and havent come up with much. Other than you can write your own in any language that allows you to create a DLL. I know VS.net C++ comes with an "Extended Stored Procedure dll" project. I really dont have time to learn C++.
Anyways, does anybody know of any good articles explaining this or know where I could get some good examples. Or, if somebody could explain the mechanics of it to me as far as how the class needs to be setup or references I would need, etc. I tried creating a class that had one function in it and then I registered it in SQL Server
(exec sp_addextendedproc EXtendsp, EXtendsp.dll)
but I get the error
(ODBC: Msg 0, Level 16, State 1
Cannot find the function EXtendsp in the library EXtendsp.dll. Reason: 127(The specified procedure could not be found.).)
Any help would be greatly appreciated, thanks in advance.
Anyways, does anybody know of any good articles explaining this or know where I could get some good examples. Or, if somebody could explain the mechanics of it to me as far as how the class needs to be setup or references I would need, etc. I tried creating a class that had one function in it and then I registered it in SQL Server
(exec sp_addextendedproc EXtendsp, EXtendsp.dll)
but I get the error
(ODBC: Msg 0, Level 16, State 1
Cannot find the function EXtendsp in the library EXtendsp.dll. Reason: 127(The specified procedure could not be found.).)
Any help would be greatly appreciated, thanks in advance.
