sending a http request from a stored proc

• ukeen

  SSC Rookie

  Points: 42

  More actions

  July 8, 2003 at 4:58 am

  #82083

  Hi, i am trying to figure out how to send a http request such as

  http://server.com/index.asp?parm1=???&parm2=??? etc

  where the parms are retrieced from a query

  thanks in advance for any suggestions/help

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  July 8, 2003 at 5:17 am

  #464446

  You can use sp_OACreate to Instantiate the XMLHTTP (MSXML.HTTP).

  You then use the Appropriate sp_OA procs to set the properties and methods.

  BOL has plenty worth while examples.

  Cheers,

  Crispin

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  July 8, 2003 at 5:24 am

  #464448

  Here's an old thread where it's done.

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11078&FORUM_ID=9&CAT_ID=1&Topic_Title=dead+links&Forum_Title=General

  Cheers,

  Crispin

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• ukeen

  SSC Rookie

  Points: 42

  More actions

  July 8, 2003 at 5:29 am

  #464450

  Crispin thanks for the pointer. I'll check it out.