Error 80040e07

[u_goldman]

Depende de tu base de datos:

Si es access, ademas de las almohadillas tienes que pasar un string (si no me equivoco, tiene
muchisimo que no trabajo con access)
Si es cualquier cosa que no sea access, tiene que ser un string

Access:

Código ASP:

MainSQL = "Select ID,eventdate,eventtime,eventname,eventdesc from 
tblcalendar where eventdate between '# " & godatefirst & "#' AND '#" & godatelast & "#' AND active = 1 order by eventdate,eventtime;"
 

No Access:

Código ASP:

MainSQL = "Select ID,eventdate,eventtime,eventname,eventdesc from 
tblcalendar where eventdate between '" & godatefirst & "' AND '" & godatelast & "' AND active = 1 order by eventdate,eventtime;"