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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return a strong typed Dataset from a WebService to my Client? 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Sign/encrypt a webservice call with an eToken 0
webservice 1
Scalability questions.... 6
Invalid Column Name Sql-Error :Executing a stored procedure 1
Scalability question 2
executing scripts within a web browser control under the system ac 2

Back
Top