Hi friends,
Please someone how to create a dll in vb. net class library , how to register it and how to call it using sp_oacreate. Pls provide some sample codes.
deepukng 0 Newbie Poster
Recommended Answers
Jump to PostNot sure how detailed or "basic" help you need but let's start with this.
1) Create a VB.NET project and add a class in it.
Public Class Class1 Public Sub New() ' Initialize class End Sub ' Add properties ' Add methods End Class
I created …
Jump to PostWhat was the exact error you get when registering? Did you use regasm? If so, did you notice my comment of fully qualifying the regams path.
The second approach was to make a COM-compatible component by setting from classes properties "COM Class = True", compile and use regsvr32. But …
Jump to PostYou will also need to give the user in SQL Server "special" permission to run external DLL's. See the documentation for sp_oacreate.
Jump to PostTeme64 already showed you how to create a class in vb.Net, compile the code to a DLL, and register it.
If you are using VS just go to the BUILD menu item and it will be done for you automatically.
What problem are you having with Teme65's instructions?
All 13 Replies
Teme64 215 Veteran Poster
deepukng 0 Newbie Poster
Teme64 215 Veteran Poster
deepukng 0 Newbie Poster
Teme64 215 Veteran Poster
deepukng 0 Newbie Poster
Teme64 215 Veteran Poster
deepukng 0 Newbie Poster
Teme64 215 Veteran Poster
deepukng 0 Newbie Poster
CornerAnalyst 0 Newbie Poster
Teme64 215 Veteran Poster
CornerAnalyst 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.