Query MySQL Database Using ASP.

I wish draw data from a MySQL Database using ASP.

The Code I have so far:

<%
dim adoConn, adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart"
adoRS.ActiveConnection = adoConn
%>

and in the asp page code:

116. <%=rsDaySummary.fields("PageViews")%>

This is obviously wrong as it returns this error:

Microsoft VBScript runtime error '800a01a8'
Object required: ''
/stats.asp, line 116

Any pointers would be appreciated.