I built an events calendar using classic ASP and an Access 2000 database back when 2000 was the current version, and it was working fine. Now I've uploaded the calendar to my domain on Hostgator, who I assume is using a newer version, and this code gives me an internal server error:
I have similar code elsewhere in the calendar where I build the sql string using variables, like this:
sql = "SELECT DISTINCT SBDC from locations ORDER BY SBDC"
and that seems to work fine. Any idea why defining sql as a simple string would cause problems?
sql = "some string"
sql = sql & "some other string"
sql = sql & some variable