Extended SP in VB.net

[bfellwock]

I want to write an extended Stored Procedure in VB.net. I have searched the net pretty extensively and haven't 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 don't 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.

[Derek Stone]

Extended stored procedures have to be written in a language that supports standard libraries. C/C++ does have that support. .NET does not.