Writing Custom DLLs in VB.net 2

[Guest]

Happy monday to all who read this...

How would I go about creating a custom dll in VB.net 2 that I can use to
make custom functions (extended stored procedures) for SQL2000/2005? Is
there an example out there of one I can model mine after?

Thanks

~Dan Regalia

 

[rowe_newsgroups]

Unless things have changed VB.Net cannot write extended stored
procedure dlls. I believe you have to use C (yes C not C#) or C++ to
build one. Things may have changed however, as this isn't something
that I keep track of. Also, I know there were 3rd party tools for VB6
that could accomplish this, so I'm sure there are some for VB.Net by
now if you are willing to to purchase them.

Good Luck!

Seth Rowe

 

[Guest]

yeah, this was a problem way back in 2002, and I was under the assumption
that they would correct this...

I mean, it would only make sense that they would make .net code all compile
the same way... eg, c# and vb all compile the same, it's just written
differently.

Thanks tho, I've been hunting this down now for a few hours, and the only
article I can find on it is over 4 years old...

Hopefully someone else might be able to shed some light on this.

 

[Marina Levit [MVP]]

This is not correct. You can write stored procedures and other things for
SQL server 2005 using .NET 2.0.

Here is a link to get started:
http://msdn2.microsoft.com/en-us/sql/aa336358.aspx

 

[rowe_newsgroups]

Thanks for correcting me! Unfortunately for me, my workplace is still
using SQL Server 2000. Oh well maybe they'll upgrade next year

Thanks,

Seth Rowe

This is not correct. You can write stored procedures and other things for
SQL server 2005 using .NET 2.0.

Here is a link to get started:
http://msdn2.microsoft.com/en-us/sql/aa336358.aspx