Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-13 : 09:45:23
|
| Tristan writes "Hi guys, can you please advice on whether there is an SQL equivalent to the below ASP code? My requirement is to use http in SQL 2000 to grab an XML file from a specified url, parse it and stored the required information back into the database. Can this be done? I tried to do it in VBscript in a job and it seems to hang at that step. Thanks in advance. Set xmlobj = Server.CreateObject("MSXML2.ServerXMLHTTP.4.0") xmlobj .open "GET", "http://www.somewhere.com", false xmlobj .send strXML = xmlobj.responseText 'Then parse the strXML " |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-13 : 10:38:09
|
| Heres some examples using WinHttp5 - same principle[url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=18425[/url]HTHJasper Smith |
 |
|
|
|
|
|
XML and SQL 2000