How to access Webservice from SQL Server 2000

Hi All,
How to access / invoke a webservice from SQL Server 2000? i.e, from within a
SP i would like to call an existing webservice.
I know using HTTPEndPoints we can do that in SQL 2005. Is there any work
arounds in SQL 2k?
Regards
PradeepI am not too sure whether this is what you are looking for! Anyways just
check this out
http://msdn.microsoft.com/msdnmag/issues/02/05/SQLXML3/ -- Build
Data-Driven Web Services with Updated XML Support for SQL Server 2000
Best Regards
Vadivel
http://vadivel.blogspot.com
"SqlBeginner" wrote:

> Hi All,
> How to access / invoke a webservice from SQL Server 2000? i.e, from within
a
> SP i would like to call an existing webservice.
> I know using HTTPEndPoints we can do that in SQL 2005. Is there any work
> arounds in SQL 2k?
> Regards
> Pradeep|||It's not easy and I'm not sure if you can do it but you may be able to
access a DLL from the sp_OA* OLE automation procs. The DLL would likely
need to have a COM+ wrapper. The DLL would then call the web service. I
haven't tried this, though.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"SqlBeginner" <SqlBeginner@.discussions.microsoft.com> wrote in message
news:9B8A5DE2-08AB-4BCB-9EA7-1557D6CE7541@.microsoft.com...
Hi All,
How to access / invoke a webservice from SQL Server 2000? i.e, from within a
SP i would like to call an existing webservice.
I know using HTTPEndPoints we can do that in SQL 2005. Is there any work
arounds in SQL 2k?
Regards
Pradeep|||Just make sure it doesn't wrap any managed code:
http://support.microsoft.com/defaul...kb;en-us;322884
:-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OvPR%23LyfGHA.2188@.TK2MSFTNGP04.phx.gbl...
> It's not easy and I'm not sure if you can do it but you may be able to
> access a DLL from the sp_OA* OLE automation procs. The DLL would likely
> need to have a COM+ wrapper. The DLL would then call the web service. I
> haven't tried this, though.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "SqlBeginner" <SqlBeginner@.discussions.microsoft.com> wrote in message
> news:9B8A5DE2-08AB-4BCB-9EA7-1557D6CE7541@.microsoft.com...
> Hi All,
> How to access / invoke a webservice from SQL Server 2000? i.e, from within
a
> SP i would like to call an existing webservice.
> I know using HTTPEndPoints we can do that in SQL 2005. Is there any work
> arounds in SQL 2k?
> Regards
> Pradeep
>|||Well, there ya go. Another reason to move on to SQL 2005. ;-)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uA0$eYyfGHA.1792@.TK2MSFTNGP03.phx.gbl...
Just make sure it doesn't wrap any managed code:
http://support.microsoft.com/defaul...kb;en-us;322884
:-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OvPR%23LyfGHA.2188@.TK2MSFTNGP04.phx.gbl...
> It's not easy and I'm not sure if you can do it but you may be able to
> access a DLL from the sp_OA* OLE automation procs. The DLL would likely
> need to have a COM+ wrapper. The DLL would then call the web service. I
> haven't tried this, though.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "SqlBeginner" <SqlBeginner@.discussions.microsoft.com> wrote in message
> news:9B8A5DE2-08AB-4BCB-9EA7-1557D6CE7541@.microsoft.com...
> Hi All,
> How to access / invoke a webservice from SQL Server 2000? i.e, from within
> a
> SP i would like to call an existing webservice.
> I know using HTTPEndPoints we can do that in SQL 2005. Is there any work
> arounds in SQL 2k?
> Regards
> Pradeep
>|||How many web services actually existed in 1999/2000?
ML
http://milambda.blogspot.com/|||Well said.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"ML" <ML@.discussions.microsoft.com> wrote in message
news:DDACAEC9-BF52-48F2-9C9E-5E4E0E27433D@.microsoft.com...
How many web services actually existed in 1999/2000?
ML
http://milambda.blogspot.com/