Stored Procedure Calling VB.NET code

Hi. For my current project, I have to write a stored procedure that calls VB.NET code. Is there any sites that provide info on how to do this? Thanks a lot for information.

bruce
Thu Feb 05 12:01:39 CST 2004

you have to create a com automation object, then install it on the
sqlserver. after you create and debug you object see sp_OA* system stored
procs

-- bruce (sqlwork.com)


"Anonymous" <anonymous@discussions.microsoft.com> wrote in message
news:DEEB165C-88D2-454A-918F-B500D1F8AE19@microsoft.com...
> Hi. For my current project, I have to write a stored procedure that calls
VB.NET code. Is there any sites that provide info on how to do this? Thanks
a lot for information.

Patrick
Thu Feb 05 12:09:32 CST 2004

In article <DEEB165C-88D2-454A-918F-B500D1F8AE19@microsoft.com>,
anonymous@discussions.microsoft.com says...
> Hi. For my current project, I have to write a stored procedure
> that calls VB.NET code. Is there any sites that provide info
> on how to do this? Thanks a lot for information.

http://weblogs.asp.net/dneimke/archive/2004/01/31/65330.aspx

--
Patrick Steele
Microsoft .NET MVP
http://weblogs.asp.net/psteele

anonymous
Thu Feb 05 12:16:05 CST 2004

Thanks a lot, Bruce Barker. Is there any sites that provide info on how to do that? Thanks.

anonymous
Thu Feb 05 12:26:08 CST 2004

Thanks, Mr. Steele and Mr. Barker. Is there any way that the SQL Server Stored Procedure can call a .NET class instead of a COM object? Thanks for info.

William
Thu Feb 05 13:22:21 CST 2004

That's coming. The Yukon release of SQL Server supports calling C# and
VB.NET code from stored procedures (and more). What is it that you're trying
to do in this called function?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________

"Anonymous" <anonymous@discussions.microsoft.com> wrote in message
news:A8AB0F51-C26A-46FD-B0FE-A94ED0E6CD32@microsoft.com...
> Thanks, Mr. Steele and Mr. Barker. Is there any way that the SQL Server
Stored Procedure can call a .NET class instead of a COM object? Thanks for
info.

anonymous
Thu Feb 05 13:41:11 CST 2004

Thanks.

I am not totally sure what my function does. My boss asked me to do research on how to call VB.NET code from a stored procedure in SQL Server. I have a belief my boss wants to call this VB.NET code from a stored procedure that to have all code in T-SQL because VB.NET code can be used to do more things than T-SQL code.

William
Thu Feb 05 19:55:57 CST 2004

Have your boss give me a call and we can talk. It's not particularly
efficient to call out of a SP. There are isolated cases where this makes
sense but as a general rule, it's not a good idea--especially not before
Yukon.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________

"Anonymous" <anonymous@discussions.microsoft.com> wrote in message
news:3A9D5B4D-B122-440F-9F8F-941EE6027228@microsoft.com...
> Thanks.
>
> I am not totally sure what my function does. My boss asked me to do
research on how to call VB.NET code from a stored procedure in SQL Server.
I have a belief my boss wants to call this VB.NET code from a stored
procedure that to have all code in T-SQL because VB.NET code can be used to
do more things than T-SQL code.