Rename dbo.Order? UPS Worldship Problem

With the table dbo.Order I am having a import problem.  If I rename the table dbo.Order1 it goes away.  Does anyone know how to fix this?  I know that if I find the right spot and put Brackets around [Order] it would work fine, but not sure where to fix.  With UPS Worldship I can now make shipping labels much faster if the import worked.

Here is the error

ImEx Error log 28/11/2012 06:29:19 importexportodbc.cpp, 186 ODBC ERROR: State = 37000 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Order'.

What is a workaround for this?  Please Help.

Yes, you need to put put brackets around Order - [Order], or write it as dbo.Order
I don't know much about WorldShip except that you need to create a map in their software.  Try to put the brackets or "dbo." prefix in the map.  You may want to get support from them.

New York wrote:

I think I just fixed it by making a view called MyOrders off of the Order table.

Any time you have a table or column that shares a name with a reserved word you need to wrap your's in [ ].  Key, Value, Order are usually the ones that I run into the most.

I will be tackling export to WorldShip soon. Once I find a solution (or create one) I'll share it.

e-novative wrote:

I have made a export map to Worldship.  The only problem I am have now is making a import map into nopcommerce and adding shipments from Worldship Export map.

Making a view called something else out of the Order table fixes the problem with the name.

I am getting same error

ImEx Error log 12/03/2014 13:46:57 importexportodbc.cpp, 170 ODBC ERROR: State = 37000 Error = [MySQL][ODBC 3.51 Driver][mysqld-5.5.36-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order' at line 1

Not sure how to resolve this.

we can not rename but where to fix it.

How to implement view concept

Please help