If you get an error like this is it possible you are using a reserved word in your SQL - please see http://support.microsoft.com/default.aspx?scid=kb;EN-US;248738 for a list of resevereved words.
If you are using a reserved work you can usually get around the issue by enclose the field name in square brackets, eg...
SELECT [reservWordFieldName] FROM myTable;
