TheReverendSoleil
New Member
Because of my version of Xcelsius I'm limited to 2 web service connections so I tried using XML Data connection and aspx page to bring data from database to Xcelsius.
I have an ASPX page that outputs an xml file with the format
\[code\]<data><variable name=""><row><column></column>...</row></variable>...</data>\[/code\]In Xcelsius I made a XML Data connection having the XML URL pointing to the .aspx page that should output an xml. Then I have the Enable Load checked and I have selected the proper # of cells and rows . If I try preview I get\[code\]"An error has occurred. For more information, contact the file creator or yoursystem administrator. Error: Error #2032 Connection Type: XML Data".\[/code\]I have the crossdomain.xml file on both the application folder and IIS wwwroot folder that looks like this:
\[code\]<?xml version="1.0" ?> <!DOCTYPE cross-domain-policy SYSTEM "http://www.macromedia.com/xml/dtds/cross-domain- policy.dtd"> <cross-domain-policy> <allow-access-from domain="*" secure="false" /> <allow-http-request-headers-from domain="*" headers="*" secure="false"/> </cross-domain-policy>\[/code\]If I put in the XML URL in Xcelsius, the url to the xml file directly without using .aspx to write it to the output of the page it works. The xml is in the same application folder as .aspx page.
My scope is to use the .aspx page to write query on the database and output back an xml with the table in the correct xml format so I can then consume the data in Xcelsius.Does anybody know how to fix the error or other ways I can bring data from database into Xcelsius?My version of Xcelsius: Engage 5.4.0.0
I have an ASPX page that outputs an xml file with the format
\[code\]<data><variable name=""><row><column></column>...</row></variable>...</data>\[/code\]In Xcelsius I made a XML Data connection having the XML URL pointing to the .aspx page that should output an xml. Then I have the Enable Load checked and I have selected the proper # of cells and rows . If I try preview I get\[code\]"An error has occurred. For more information, contact the file creator or yoursystem administrator. Error: Error #2032 Connection Type: XML Data".\[/code\]I have the crossdomain.xml file on both the application folder and IIS wwwroot folder that looks like this:
\[code\]<?xml version="1.0" ?> <!DOCTYPE cross-domain-policy SYSTEM "http://www.macromedia.com/xml/dtds/cross-domain- policy.dtd"> <cross-domain-policy> <allow-access-from domain="*" secure="false" /> <allow-http-request-headers-from domain="*" headers="*" secure="false"/> </cross-domain-policy>\[/code\]If I put in the XML URL in Xcelsius, the url to the xml file directly without using .aspx to write it to the output of the page it works. The xml is in the same application folder as .aspx page.
My scope is to use the .aspx page to write query on the database and output back an xml with the table in the correct xml format so I can then consume the data in Xcelsius.Does anybody know how to fix the error or other ways I can bring data from database into Xcelsius?My version of Xcelsius: Engage 5.4.0.0