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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 HTTP XML

Author  Topic 

NickyJ
Starting Member

46 Posts

Posted - 2005-10-14 : 06:31:00
I am trying to return data via an ASP page from a URL using xmlhttp object, code as follows :

<%@language=JScript%>
<%
var objSrvHTTP;
objSrvHTTP = Server.CreateObject ("Msxml2.ServerXMLHTTP.3.0");
objSrvHTTP.open ("GET","http://www.someserver.com/staffing/api/PublicJobPostingsCSV.cfm?privateLabelID=000750&encryptedAPIKey=%23%4354BO%29%0A", false);
objSrvHTTP.send ();
Response.ContentType = "text/xml";
Response.Write (objSrvHTTP.responseXML.xml);
%>

Error returned is

msxml3.DLL error '80072ee7'

The server name or address could not be resolved

/uk/vacancies/Test4.asp, line 7


Thanks in advance for any suggestions.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-10-14 : 07:58:43
Seems pretty straightforward, the URL you're passing can't be found/resolved.
Go to Top of Page

NickyJ
Starting Member

46 Posts

Posted - 2005-10-14 : 08:05:09
If I paste the URL into my browser it does pop-up a windows to save a file, so can be found.
Go to Top of Page

HCLollo
Starting Member

49 Posts

Posted - 2005-10-14 : 08:25:01
Nicky, try something like URLEncode/URLDecode on your URL string
(don't have the manual right here at the moment, but it's something
like that...)

HCL


"If it works fine, then it doesn't have enough features"
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-10-14 : 08:27:45
is it an XML file on the other side?

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -