I have a ASP/VB Script that I need converted to SQL for use in a Stored Procedure. Basically the script uses the http object to download a file.
The SP_OACreate procedure will need to be used to create the object. I have tried, but can't seem to figure out the arguments when running SP_OAMethod. There may also be another way of doing this...who knows? Hopefully you!
sSource = http://www.mygolfgear.com/products/iStourplusequilizer.jpg
sDest = C:\temp\iStourplusequilize
set oHTTP = Server.CreateObject("Micro
oHTTP.open "GET", sSource, False
set oStream = server.createobject("adodb
Const adTypeBinary = 1
Const adSaveCreateNotExist = 1
Const adSaveCreateOverWrite = 2
oStream.type = adTypeBinary
oStream.savetofile sDest, adSaveCreateOverWrite
set oStream = nothing
set oHTTP = nothing