Call a WebService from within a Stored Procedure...

[Guest]

Visual Studio 2003 / SQL Server 2000

Is it possible to call a webservice from a stored procedure?

I have a field system with SQL CE on it, this talks to a SQL backend, but
that then needs to talk to another none microsoft application(Progress) which
can be exposed via webservices. Is this possible??

Thanks

 

[Guest]

Steve,

I've manages this with Oracle 9i, which has some low level http/soap
procedures built in. You have to manually construct a valid soap message,
send it, and consume the reply. A bit of a chore, which I understand is
easier in 10g.

Completely unsure about SQL CE. What provides you SQL back end ? SQL Server ?

 

[Guest]

Yes, the backend is SQL Server talking to a SQL CE client on the PDA. When
the client talks to the SQL Server backend, I need it to call some web
services that I have generated to expose our Progress DB