[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

How to create extended stored procedure in VB ?

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
kishore_peddi
Asked:
kishore_peddi
  • 3
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
use C / C++  or Delphi instead of  VB
0
 
Vadim RappCommented:
or use http://www.vbadvance.com/ to wrap vb project as standard dll, which extended procedure should be.
0
 
Vadim RappCommented:
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
 
Vadim RappCommented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now