Solved

How to create extended stored procedure in VB ?

Posted on 2006-06-16
7
184 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
7 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 500 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now