Software FX Posted February 25, 2000 Report Share Posted February 25, 2000 ChartFX request the files to be downloaded to Explorer so any settings used in Explorer will affect how files are downloaded. Please check the HTML source that gets to the client. You will typically see something like <OBJECT ...> <PARAM NAME="LICENSE" VALUE="/License/CfxIE.lic"> <PARAM NAME="DATAPATH" VALUE="/CfxTemp/XXXXXX.chw"> </OBJECT> ChartFX will try to download the "/License/CfxIE.lic" and "/CfxTemp/XXXXXX.chw" URLs, it does so by requesting the files to IE so any network settings in IE will apply. I connected to your viewchart.asp and I got the following <OBJECT CLASSID="CLSID:21F49842-BFA9-11d2-A89C-00104B62BDDA" TYPE="application/x-oleobject" WIDTH="600" HEIGHT="380" ID="Chart1" CODEBASE=/download/CfxIEAx.cab#Version=4,4,15,0 > <PARAM NAME="LICENSE" VALUE="/license/CfxIE.lic"> <PARAM NAME="DATAPATH" VALUE="/cfxtemp/CFT0225_104126167.chw"> </OBJECT> I then wrote the following URLs in my address bar http://www.earthcareus.com/License/CfxIE.lic and I got the file http://www.earthcareus.com/cfxtemp/CFT0225_104126167.chw and I got a 404 error. Check the CfxTemp folder, can you see the CHW files there ? Do you have a virtual directory called CfxTemp pointing to the CfxTemp folder ? Is this the folder where you checked the NT permissions ? Did you check the virtual directory settings ? Regards, Juan Cegarra Software FX, Inc. http://support.softwarefx.com -----Original Message----- From: Mark Tate [ mailto:mttate@allentate-com.com] Posted At: Friday, February 25, 2000 9:31 AM Posted To: Server Conversation: Can not download chart data Subject: Re: Can not download chart data Ok, I created just a simple chart using the following code: <% Set Chart1 = Server.CreateObject("ChartFX.WebServer") %> <%= Chart1.GetHtmlTag(400,200,"Auto") %> It works fine on the local network, but not from outside. One thing that maybe I should mention is that I'm doing address translation via a proxy server to specific web sites. Will ChartFX operate behind a proxy? Mark Tate <mttate@allentate-com.com> wrote in message news:DE0379D14694D211B4CE00609770710D04B67C@sftfx-221.wamnet.net... > ok, I checked the permissions and it was set up for everyone to have full > control.. I added the IUSR/ComputerName account just in case and gave Change > permissions as suggested, but it's still no help. I have 2 virtual > directories set up under my root web site, those being CFXIETemp and > License. Both virtual directories are set up as applications. > > I also tried to use a ODBC connection by using ' conn.Open > Application("myDSNname") ', using a SERVER DSN and I started getting > 80004005 errors, both inside and outside the local network. I don't know if > that is in anyway related, but maybe it's worth a mention. I noticed that > CFX set up a Server DSN, so is there a quick test I can do using it as a DSN > to try and further isolate the problem? > > I can't fathom what the difference would be between requesting the data > while inside the local network as opposed to outside the local network. I > will try hard coding a chart to make sure that the chart object will > initiate from both inside and outside the local network to isolate whether > it's a chart problem in whole, or just a data connection problem. > > Thanks for your support in this process.. > Juan Cegarra <JuanC@softwarefx.com> wrote in message > news:DE0379D14694D211B4CE00609770710D04B676@sftfx-221.wamnet.net... > > When I connected to your original page (viewchart.asp) my chart says > > "Failed to download chart data". > > > > Please check the permissions on the CfxTemp folder, you may want to > > check that the NT permissions on this folder are set to "Change" for the > > user impersonated by IIS (IUSR_MachineName) and you may also want to > > check the existence of a virtual directory called License that points to > > the license folder (this Virtual directory needs only read permissions > > inside the IIS Manager) > > > > Regards, > > > > Juan Cegarra > > Software FX, Inc. > > http://support.softwarefx.com > > > > > > -----Original Message----- > > From: Mark Tate [ mailto:mttate@allentate-com.com] > > Posted At: Thursday, February 24, 2000 2:23 PM > > Posted To: Server > > Conversation: Can not download chart data > > Subject: Re: Can not download chart data > > > > > > Assuming no response means that the problem is on my side, I created 2 > > other > > pages using the same query. One page creates the chartfx object to show > > the > > code, the other page shows a recordset column in a table. Here's the > > code: > > > > Page 1: (www.earthcareus.com/page5.asp) > > > > <HTML> > > <BODY> > > <DIV ID=[name] style="position:absolute; left:[left]; top:[top]; > > width:[width]; height:[height]"> > > <% > > ' Create Data for Chart > > query = "select distinct surveyquestions.question_name, > > surveyquestions.question_number, " > > query = query + "(select count(*) from answers where answers.answer = > > 'YES' > > and answers.id_survey = 2 and answers.id_questions = " > > query = query + "surveyquestions.question_number) as 'Yes Answers', " > > query = query + "(select count(*) from answers where answers.answer = > > 'NO' > > and answers.id_survey = 2 and answers.id_questions = " > > query = query + "surveyquestions.question_number) as 'No Answers' from > > surveyquestions, answers where surveyquestions.id_survey = 2 order by > > surveyquestions.question_number" > > > > Set conn = Server.CreateObject("ADODB.Connection") > > Set rs = Server.CreateObject("ADODB.Recordset") > > Set cmd = Server.CreateObject("ADODB.Command") > > > > conn.open "DSN=EarthCare;", "earthcare", "earthcare" > > cmd.CommandText = query > > cmd.CommandType = 1 > > Set cmd.ActiveConnection = conn > > rs.Open cmd, , 1, 1 > > %> > > <table border = 1> > > <%while not rs.eof %> > > <tr><td><%=rs("Yes Answers")%></td><tr> > > <% rs.MoveNext > > wend > > %> > > </table> > > <% > > rs.close > > conn.close > > %> > > > > <%=chart.GetHtmlTag("600","380")%> > > </DIV> > > </BODY> > > </HTML> > > > > Page 2: (www.earthcareus.com/page6.asp) > > > > <HTML> > > <BODY> > > <DIV ID=[name] style="position:absolute; left:[left]; top:[top]; > > width:[width]; height:[height]"> > > <% > > > > ' Create Data for Chart > > query = "select distinct surveyquestions.question_name, > > surveyquestions.question_number, " > > query = query + "(select count(*) from answers where answers.answer = > > 'YES' > > and answers.id_survey = 2 and answers.id_questions = " > > query = query + "surveyquestions.question_number) as 'Yes Answers', " > > query = query + "(select count(*) from answers where answers.answer = > > 'NO' > > and answers.id_survey = 2 and answers.id_questions = " > > query = query + "surveyquestions.question_number) as 'No Answers' from > > surveyquestions, answers where surveyquestions.id_survey = 2 order by > > surveyquestions.question_number" > > > > Set conn = Server.CreateObject("ADODB.Connection") > > Set rs = Server.CreateObject("ADODB.Recordset") > > Set cmd = Server.CreateObject("ADODB.Command") > > > > conn.open "DSN=EarthCare;", "earthcare", "earthcare" > > cmd.CommandText = query > > cmd.CommandType = 1 > > Set cmd.ActiveConnection = conn > > rs.Open cmd, , 1, 1 > > Set chart = Server.CreateObject("ChartFX.WebServer") > > chart.Title(2) = "Employee Satisfaction Survey Questions" > > chart.AdoResultSet rs > > chart.Gallery = 2 > > rs.close > > conn.close > > %> > > > > <%=chart.GetHtmlTag("600","380")%> > > </DIV> > > </BODY> > > </HTML> > > > > Both pages display properly on computers that are part of the same > > domain as > > the webserver that creates the chartfx object. However, on computers > > that > > are not part of the same domain as the webserver, the page displaying > > the > > result set in a table works fine, but the page displaying the result set > > as > > a chart does not work saying that 'chart data can not be downloaded'. > > Can > > someone please explain this? > > > > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.