Load xml with asp extension
Hi,
I am trying to load an xml file with asp extension, i.e sqlXml.load("path/myfile.a
I know that the problem is because I am trying to load the asp file from a physical path and not through HTTP, but I am not sure how to load the xml from HTTP cuz I am loading the xml from global.asa and the path is not always the same...
appreciate any help
Thanks
I am trying to load an xml file with asp extension, i.e sqlXml.load("path/myfile.a
I know that the problem is because I am trying to load the asp file from a physical path and not through HTTP, but I am not sure how to load the xml from HTTP cuz I am loading the xml from global.asa and the path is not always the same...
appreciate any help
Thanks
Last Comment
Badotz
So, why change the extension from .xml to .asp? Leave it alone!
before the
sqlXml.load("path/myfile.a
put
sqlXml.setProperty "ServerHTTPRequest", true
and make sure you include the http://mydomain.com/mypath/to/the/asp/file.asp
sqlXml.load("path/myfile.a
put
sqlXml.setProperty "ServerHTTPRequest", true
and make sure you include the http://mydomain.com/mypath/to/the/asp/file.asp
Yeah, but if it ain't broke, why fix it?
i think what he is saying is that he has tried using a xml file and it works but as soon as he tried to create a dynamic XML file with ASP it doesnt work, but he knows for the ASP to execute correctly it has to be called via http
b
b
gotcha - well, until we hear back from dxz2, we won't know what he is thinking ;-)
ASKER
Hi,
I will try B_Dorsey suggestion tomorrow at work.
Why changing xml to asp? because there is sensitive data inside the xml file and I created some kind of server side authentication to disable xml file to be directly viewed in browsers
B_Dorsey what do you mean by "and make sure you include the http://mydomain.com/mypath/to/the/asp/file.asp"
Thanks
-dirar
I will try B_Dorsey suggestion tomorrow at work.
Why changing xml to asp? because there is sensitive data inside the xml file and I created some kind of server side authentication to disable xml file to be directly viewed in browsers
B_Dorsey what do you mean by "and make sure you include the http://mydomain.com/mypath/to/the/asp/file.asp"
Thanks
-dirar
>> cuz I am loading the xml from global.asa
That is pretty secure, no?
That is pretty secure, no?
ASKER
Hi B_Dorsey,
This is what I am doing:
Set sqlXml = Server.CreateObject("MSXML
path = Server.MapPath("../../xml/
sqlXml.setProperty "ServerHTTPRequest", true
sqlXml.load path
did not work
I then added:
sqlXml.async = false
sqlXml.validateOnParse = false
And it worked
Thanks a lot the sqlXml.setProperty was I am missing
This is what I am doing:
Set sqlXml = Server.CreateObject("MSXML
path = Server.MapPath("../../xml/
sqlXml.setProperty "ServerHTTPRequest", true
sqlXml.load path
did not work
I then added:
sqlXml.async = false
sqlXml.validateOnParse = false
And it worked
Thanks a lot the sqlXml.setProperty was I am missing
ASKER
:) my bad I am sorry
no it didn't work till now I thought I changed the path
should be
path = Server.MapPath("../../xml/
any suggestions
no it didn't work till now I thought I changed the path
should be
path = Server.MapPath("../../xml/
any suggestions
a ASP page needs to be executed.. I didnt know you could use ../ in Server mappath... so try the suggestions below...
Set sqlXml = Server.CreateObject("MSXML
sqlXml.setProperty "ServerHTTPRequest", true
sqlXml.Load Server.MapPath("/xml/DBQUE
Set sqlXml = Server.CreateObject("MSXML
sqlXml.setProperty "ServerHTTPRequest", true
sqlXml.Load Server.MapPath("http://www.mydomain.com/xml/DBQUERY.asp") 'Replace my domain with the domain name
Set sqlXml = Server.CreateObject("MSXML
sqlXml.setProperty "ServerHTTPRequest", true
sqlXml.Load Server.MapPath("/xml/DBQUE
Set sqlXml = Server.CreateObject("MSXML
sqlXml.setProperty "ServerHTTPRequest", true
sqlXml.Load Server.MapPath("http://www.mydomain.com/xml/DBQUERY.asp") 'Replace my domain with the domain name
ASKER
I get "Invalid xml declaration" I think this is because of the <%%> in asp
-dirar
-dirar
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I gad to start the document with
<?xml version="1.0" encoding="utf-8"?>
instead with <%%>
and it worked
thanks
<?xml version="1.0" encoding="utf-8"?>
instead with <%%>
and it worked
thanks
ASP
Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.
82K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
