Stored Procedure Calling VB.NET code

[Guest]

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 barker]

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)

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 Steele [MVP]]

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

 

[Guest]

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

 

[Guest]

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 \(Bill\) Vaughn]

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.
__________________________________

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.

 

[Guest]

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 \(Bill\) Vaughn]

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.
__________________________________

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.