User (Legacy) Posted February 25, 2000 Report Share Posted February 25, 2000 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.