Wrting extended stored procedures with vb.net/c#

10 May 2005 6:06 PM

DLS

Are there any references and samples of writing extended stored procedures
using vb.net/c#? Since we can't use vb or java, does the same restriction
apply?

10 May 2005 6:19 PM

David Gugick

DLS wrote:

> Are there any references and samples of writing extended stored
> procedures using vb.net/c#? Since we can't use vb or java, does the
> same restriction apply?

I believe C/C++ are your only options with SQL 7/2000. Only SQL Server
2005 supports CLR procedures. See "Creating Extended Stored Procedures"
in BOL for some basic information.

--
David Gugick
Imceda Software
www.imceda.com

17 May 2005 9:24 AM

Gert E.R. Drapers

Technically it would be possible, but it is not supported.
http://support.microsoft.com/default.aspx?scid=kb;en-us;322884

You can look it to using sp_OA to call in to COM automation objects, so you
can use VB6 for example.

Ge***@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

Show quote

"David Gugick" <davidg-nospam@imceda.com> wrote in message
news:Ol9I$yYVFHA.3432@TK2MSFTNGP10.phx.gbl...
> DLS wrote:
>> Are there any references and samples of writing extended stored
>> procedures using vb.net/c#? Since we can't use vb or java, does the
>> same restriction apply?
>
> I believe C/C++ are your only options with SQL 7/2000. Only SQL Server
> 2005 supports CLR procedures. See "Creating Extended Stored Procedures" in
> BOL for some basic information.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com