locked
invoke a webservice from database level RRS feed

  • Question

  • This is how i create a webservice in my database .

     

    whatever URL i specify it shows internet explorer cannot display the image .

     

    How do i test the webservice from database level to know whether it's working or not.

     

    CREATE PROCEDURE [dbo].[uspGetPersonInfo]

    @ID [int]

    AS

    BEGIN

    SET NOCOUNT ON;

    SELECT [FirstName],[MiddleName],[LastName]

    FROM [AdventureWorks].[Person].[Contact]

    WHERE ContactID = @ID

    END;

     

     

    CREATE ENDPOINT SQLEP_AWPersons

    STATE = STARTED

    AS HTTP

    (

    PATH = '/AWpersons',

    AUTHENTICATION = (INTEGRATED),

    PORTS = (CLEAR),

    CLEAR_PORT = 2000,

    SITE = 'sqlidw14'

    )

    FOR SOAP

    (

    WEBMETHOD 'PersonInfo'

    (NAME='AdventureWorks.dbo.uspGetPersonInfo'),

    BATCHES = DISABLED,

    WSDL = DEFAULT,

    DATABASE = 'AdventureWorks',

    NAMESPACE = 'http://Adventure-Works/Persons'

    )

     

    Monday, November 24, 2008 5:02 PM

All replies

  • I dont think you can invoke a webservice from SSMS

     

    If I was asked I will make a small web app and add this as web reference and invoke it in a button click event. I guess this is only way. All you can do in SSMS is to validate if the SP exposed via his end point retunrs data or not

    Monday, November 24, 2008 5:30 PM
  •  

     

    For the above created process .

     

    I wnat to run an webservice task in the SSIS.where i need to specify HTTP Connection WSDL file location.

     

    How do i use the above created program at this location.

     

     

    can you guide me in using a webservice task created in database .

    Monday, November 24, 2008 7:06 PM