Home > Archive > microsoft.public.sqlserver.server > October 2002 > Calling .NET Classes from Transact SQL





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Calling .NET Classes from Transact SQL
Jason Harmon

2002-10-05, 9:08 pm

Does anyone know if there is a direct way to access .NET classes from
Transact-SQL, similar to the sp_OA.. procedures, but which do not
require a Com-Callable-Wrapper for the .NET class?

Thanks.

Jason Harmon
Tony Rogerson

2002-10-05, 9:08 pm

I think you need the COM wrapper to be honest - you can develop using .NET
and use one of the tools that ships with Visual Studio to get the wrapper -
never done it though.

--
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
http://www.sql-server.co.uk [UK User Group, FAQ, KB's etc..]
http://www.sql-server.co.uk/tr [To Hire me]


"Jason Harmon" <jharmon@us.net> wrote in message
news:9a8ae930.0209131024.5c102c76@posting.google.com...
> Does anyone know if there is a direct way to access .NET classes from
> Transact-SQL, similar to the sp_OA.. procedures, but which do not
> require a Com-Callable-Wrapper for the .NET class?
>
> Thanks.
>
> Jason Harmon



Tibor Karaszi

2002-10-05, 9:09 pm

Tony,

A KB article was released a few days ago stating the calling .NET from sp_OA% is not supported.
Q322884

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver


"Tony Rogerson" <tonyrogerson@sqlserver.eu.com> wrote in message
news:aluvol$fcj$2@nntp-m01.news.aol.com...
> I think you need the COM wrapper to be honest - you can develop using .NET
> and use one of the tools that ships with Visual Studio to get the wrapper -
> never done it though.
>
> --
> Tony Rogerson SQL Server MVP
> Torver Computer Consultants Ltd
> http://www.sql-server.co.uk [UK User Group, FAQ, KB's etc..]
> http://www.sql-server.co.uk/tr [To Hire me]
>
>
> "Jason Harmon" <jharmon@us.net> wrote in message
> news:9a8ae930.0209131024.5c102c76@posting.google.com...
> > Does anyone know if there is a direct way to access .NET classes from
> > Transact-SQL, similar to the sp_OA.. procedures, but which do not
> > require a Com-Callable-Wrapper for the .NET class?
> >
> > Thanks.
> >
> > Jason Harmon

>
>



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net