Accessing a MySQL database using html/javascript

[Lila Fowler]

Hi all,

I am trying to access a database using java script but I keep getting the following error:

"The connection cannot be used to perform this operation. It is either closed or invalid in this context."

I am using the same code in a different area of the code and it works perfectly there. Any ideas as
to why it would work in one section of the javascript and not in the other?

function getschedule()
{
         try
	{
		var conn = new ActiveXObject ("ADODB.Connection");	
		conn.open ("DSN=mydatabaseconnection");
		var rs = new ActiveXObject ("ADODB.Recordset");
	        var date = retrievedate("-");

		rs.Open("SELECT * FROM mydatabasename.stocktakeschedules WHERE scheduledate = '"+date+"'")
	
	
		alert("after select");
	
		while(!rs.EOF)
		{ 
			alert("in loop");
			var id = rs.Fields("quantity").value;
			var groupdescription = rs.Fields("description").value;
			var groupcode = rs.Fields("groupcode").value;
			var scheduletype = rs.Fields("scheduletype").value;
			var scheduledate = rs.Fields("scheduledate").value;
			alert("before populate");
			populatescheduletablelist(scheduledate, groupcode, groupdescription, scheduletype, id);
			
			rs.MoveNext();
		}
	
	}
	catch(err)
	{
		alert("m1:" + err);
	}
	
	rs.Close;
	conn.close ();
}

Thanks.