Post reply

Call a Web Service

  • November 6, 2003 at 8:59 am

    #101748

    I know calling a COM object from TSQL is possible. How about a web service? If so, any sample code you can offer would be appreciated.

    Remember this when a developer tells you it will just be temporary. Temporary = Permanent.

  • November 6, 2003 at 1:43 pm

    #481155

    Can you give more details what you want to do?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 6, 2003 at 1:48 pm

    #481159

    Sure. I have found my linked server connection between our SQL db and an Oracle db on the WAN to be unreliable. Periodically, I just can't get a connection to the Oracle DB and there is an unhelpful error associated with it.

    So, it has been determined that a web service could be written to do what my stored procedure was previously doing except it wouldn't use a linked server to accomplish the tasks. So we are looking at implementing a trigger that calls a sproc that calls a COM object that calls a web service to get data into a table in Oracle across the WAN. It seems a little redundant to me to call a COM object that has no other purpose than to call a web service and pass it the same variables that I passed it.

    Does that help?

    Remember this when a developer tells you it will just be temporary. Temporary = Permanent.

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

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