DaniWeb IT Discussion Community - View Single Post - create dll using vb.net and how to call it from sql server

Re: create dll using vb.net and how to call it from sql server

Dec 2nd, 2008

Ok. I found this MS Help and Support article: How to run a DLL-based COM object outside the SQL Server process. Read this article, it has good tips when remoting COM with SQL Server.

But first, you have to make your class a COM component by setting the class attribute "COM Class = True", or directly in the code

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
<Microsoft.VisualBasic.ComClass()> Public Class Class1
 
  Public Sub New()
    ' Initialize class
 
  End Sub
 
  Public Sub MyMethod()
 
  End Sub
 
End Class
<Microsoft.VisualBasic.ComClass()> Public Class Class1

  Public Sub New()
    ' Initialize class

  End Sub

  Public Sub MyMethod()

  End Sub

End Class

you'll have a COM component after compiling that, and you'll register COM component with regsvr32 <dllname>

I think this is more an SQL Server related issue than VB.NET. You could also re-post this question in "Web Development\MS SQL" forum here in DaniWeb.

Teme64 @ Windows Developer Blog