HTTP POST through SQL

One of the developers on my team needs to make an HTTP call in a stored procedure in SQL server 2000. This procedure runs at midnight every night and we need to send an HTTP POST at certain points throughout it. However, the developer is unsure of how to do this exactly.

Does anyone know how I can make a HTTP call in an SQL query?
dur_hannalAsked:
Who is Participating?
 
Ken SelviaConnect With a Mentor RetiredCommented:
Here is a sample of a GET from T-SQL. Might work for POST too.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=35900&whichpage=2
0
 
bukkoCommented:
Write a COM dll to do this in VB, then call the dll using

xp_OACreate
xp_OAMethod and
xp_OADestroy

bukko
0
 
dur_hannalAuthor Commented:
My developer is trying to avoid doing this using a VB component or an NT Serivce, I am told
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Anthony PerkinsCommented:
Then the developer will have to code directly against the MSXML dll using the extended stored procedures mentioned previously by bukko
0
 
dur_hannalAuthor Commented:
I will mention this to him and see what he thinks. Thanks for now.
0
 
dur_hannalAuthor Commented:
Ahhh, this looks more like it. Let me see what my developer thinks of this link. Thank you kselvia.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.