Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to create extended stored procedure in VB ?

Posted on 2006-06-16
7
Medium Priority
?
239 Views
Last Modified: 2010-03-19
Hi,

I want to create a simple extended stored procedure which prints "Hello World" in VB ! Can you please provide me sample code / link to an article in VB ?

Thanks,
Kishore
0
Comment
Question by:kishore_peddi
  • 3
  • 2
5 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16925691
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16925694
use C / C++  or Delphi instead of  VB
0
 
LVL 40

Accepted Solution

by:
Vadim Rapp earned 2000 total points
ID: 16926602
or use http://www.vbadvance.com/ to wrap vb project as standard dll, which extended procedure should be.
0
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 16926614
or, as a workaround, create activex object in vb6 and call it from tsql using sp_OAMethod. If your activex returns an array, it wil l be taken as resultset see description of sp_oamethod for details.
0
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 17627940
Objection. No offense at all, but it seems to me that aneeshattingal did not provide the solution that was requested. The request was to make it in VB, not in Delphi or C.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question