Question
February 20, 2008 at 01:03 PM
molohon

Guidance and advice requested

by molohon . Updated 18 years, 6 months ago

I need to create a process where a remote windows client can transmit an xml file via http. The data in the xml file then needs to be stored in SQL Server 2005. I’ve done some research, but would appreciate some expert advice on how to accomplish this. I’m a newbie when it comes to web services and .Net. Do I need to have a web page that receives the HTTP POST, or can this go directly into SQL Server? If it goes to SQL Server, how do I configure the connection?

Here’s the code used to transmit the xml file.
*– send information
PUBLIC lo_xml

lo_xml = CREATEOBJECT(“Msxml2.XMLHTTP”)
lo_xml.Open(“POST”, “HTTP://myurl.com”, .f.)
lo_xml.Send(lc_xmlfile)

This discussion is locked

All Comments