SQL connection not working

I have got to be doing something wrong. I have and ODBC connection defined on my local machine and on my web server that are the sme - pointing to my SQL database on the server. When I create a page with DW to access the data I can do it if I use NATIVE DW record set. I create a page am I see a single record.

I what to see more that one recored so I turn to DataAssist. I go through the process of creating the "result page" and on my local machine I see all the fields. I go to publish it to the web (using the same connection string that worked in native DW mode) and I get the error that

The Website cannot display the page
Most likely cause :
Website is under maintenace
Website has a programming error


When I look at the record set that data assist generated I see an ERROR Incorrect Syntax Near the keyword "Order" which is the first field in the view that I am connecting to?

What am I doing wrong????

Order is a reserved word in MySQL and should be avoided as a column name.


For a full list of reserved words see the following:
reserved-words.html