Can not download chart data

[User (Legacy)]

Hello, 

I'm get the above error when accessing chart data from outside our intranet. 

The page can be viewed at www.earthcareus.com/viewchart.asp 

Code to get the data is as follows (vbscript): 

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") 

conn.Open "DSN=EarthCare;", "user", "password" 

Set rs = conn.Execute(query) 

The DSN is set up as a server DSN and the user and password are both 

correct.  I've tried just using the 'DSN-less' connection above as well as 

just trying to use just the DSN name to make the connection.  Please help! 

I'm using the trial edition for now as I'm waiting for our P.O. to be 

approved. 

Mark Tate

Code.txt