Stored Procedure Calling VB.NET code

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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 said:
Hi. For my current project, I have to write a stored procedure that calls
Click to expand...
VB.NET code. Is there any sites that provide info on how to do this? Thanks
a lot for information.
 
Thanks a lot, Bruce Barker. Is there any sites that provide info on how to do that? Thanks.
 
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.
 
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 said:
Thanks, Mr. Steele and Mr. Barker. Is there any way that the SQL Server
Click to expand...
Stored Procedure can call a .NET class instead of a COM object? Thanks for
info.
 
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.
 
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 said:
Thanks.

I am not totally sure what my function does. My boss asked me to do
Click to expand...
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.
 
Back
Top