Call vb.net from SQL Server

  • Thread starter Thread starter Dave T
  • Start date Start date
D

Dave T

Does anyone know how (or if it's possible) to call a
vb.net routine from, say, a stored procedure, in SQL
Server 2000?

Thanks!
 
SQL Server has something known as extended stored procedures. These have
the capabilitiy to just call a method of a given DLL.

I would recommend you either inquire in the sql server programming
newsgroup about the details and/or search online for instructions on setting
up and using extended stored procedures.
 
Are you trying to reference a singly VB.NET module from a Stored Proc, or an
entire exectuable?

If you are trying to manipulate it programatically with so you can get
objects and the like in Stored Procs, I don't think so. You can use
xp_cmdshell to fire off a whole slew of commands, and you can run scripts
that could call you app, but the SQL Language itself doesn't know what a Foo
Object is per se..so you need something else like VB Script or something to
reference VB.NET code
 
It's funny you should ask. I'm starting a series of articles on VS.NET that
discuss how to execute CLR-based stored procedures. That is writing stored
procedures (and more) in VB.NET or any CLR-based language. It's just been
fleshed out at the PDC and made public.
Nope, this technology won't be online for some time, but if you're
considering this approach now, I would expect that it will be made obsolete
when Whidbey/Yukon hits.

No, don't ask me when it is planned to ship.

As for Extended Stored Procedures, I wrote an article on these a LONG time
ago and included this article on my book's CD (I think). The bottom line is
that there are a few good reasons/situations that call for compute-bound
processing called from a SP. However, for the most part, it's better to
stick with TSQL.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Can I humbly ask when your article(s) are going to be available ;-) ? That
is definitely going to be really really cool.
 
Ask SQL Server, MSDN or VSJ mags. ;)
That's where they're proposed to be published.
For now, check out the latest SS mag (Nov 2003). It has some of the
highlights, but little of the meat you need to know how VS.NET (Whidbey)
ties into the Yukon features.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top