Call a WebService from within a Stored Procedure...

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

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
 
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 ?
 
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
 
Back
Top