POST to http form from SQL Server

[dky1e]

Hello,

I need to (form) post to a http web page, retrieve the results and put to a table's text field.

I've tried using Msxml2.XMLHTTP object, but it either fails to post data or returns Exceptions. (no useful description)

Any suggestions, samples, or alternatives would be greatly appreciated.

Thanks!

 

[SQLSister]

How you ask for the data on your web page is really a question for the forum for whatever language you are writing your web page in.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[dky1e]

Let me give more detail.

I would like to write a stored procedure that sends a POST data to a webpage, and retrieves information returned by the page. This page retuns an xml text which I can open up using OPENXML, parse and update all the necessary fields in my database.

I have a working solution for reading data from a webpage, but I can't seem a find a way to send a POST data to a web page. It is required as the page returns different data based on the parameters posted. I cannot alter the web page.

For now I have a "hack" working. I ended up having to create and execute a vb script (on the fly) from the procedure using xp_cmdshell--it seems only way for me to get Msxml2.XMLHTTP to post data.

I'd like a cleaner solution.

I'm sorry I wasn't very clear.