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