What is the best way to have a MSSQL '05 send a SOAP request to an external web service?
-
I have been charged with creating a way for a MSSQL'05 DML action trigger a SOAP request to an external web service. This is uncharted domain for me and the only way I could think to achieve this would be to 1.) create a stored procedure to send the PK to a 2.) http://asp.net c# web service that queries the DB with the PK then formats the results into an 3.) XML/SOAP request that is then sent to the external service. Is this close to being right? Please help. I also need to be able to receive a response from the external service but that's a different story.
-
Answer:
From a security point of view, you will normally go through an application layer to consume a web service, and that's the plan you have mentioned. Although there is an easy way of using SQL server CLR to consume web service within SQL Server.
Wayne Cheng at Quora Visit the source
Related Q & A:
- How To Send a Complex Object to a Rest Web Service?Best solution by codeproject.com
- What's the best way to get a job in a restaurant?Best solution by Yahoo! Answers
- What's the best way to make a good impression at a job interview?Best solution by Yahoo! Answers
- What is the best way to send a big package to Brazil from Canada?Best solution by Yahoo! Answers
- What is the Best way to request for part time as a current full time employee?Best solution by everydaylife.globalpost.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.