Post reply

How to call a web service from T-SQL in SQL Server 2000?

  • April 20, 2006 at 9:27 pm

    #365983

    I have searched this site and done a Google search but without any results.

    Short of writing my own extended SP (which I can do if I have to but it is not an elegant solution for this problem), is there a way to do this?

  • April 24, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • April 24, 2006 at 10:59 am

    #633865

    SQL Server 2000 was released in 2000 before the Web Services with all other .NET stuff was available around 2002.

    As for Elegant Solution - you may upgrade to SQL Server 2005

    Regards,Yelena Varsha

  • April 24, 2006 at 11:55 am

    #633872

    I use sp_OACreate to employ an email sending COM object. Perhps you could do the same to use serverXMLHTTP

    [ http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290761 ]

    In ASP I use this object to request data from simply web services. Not sure at all what the issues will be trying to use it from a sstored procedure or if it would work at all for that matter. Just an idea to look into.

    Dave

    Trainmark.com IT Training B2B Marketplace
    (Jobs for IT Instructors)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply