Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

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?
0
dur_hannal
Asked:
dur_hannal
1 Solution
 
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
 
Anthony PerkinsCommented:
Then the developer will have to code directly against the MSXML dll using the extended stored procedures mentioned previously by bukko
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
dur_hannalAuthor Commented:
I will mention this to him and see what he thinks. Thanks for now.
0
 
Ken SelviaRetiredCommented:
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
 
dur_hannalAuthor Commented:
Ahhh, this looks more like it. Let me see what my developer thinks of this link. Thank you kselvia.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now