If you are connecting to a 4D Server via the ODBC Driver for 4D Server and are having problems, please be sure to follow these rules:
1) Don't have any fields in a table which are named the same. (ie: empty, empty; empty, etc...)
2) Don't use spaces in the table names. Use an underscore "_" instead. (ie: Company_Table)
3) Don't use spaces in the field names. Use an underscore "_" instead. (ie: First_Name)
To easily find the symptoms listed above, use the explorer in 4D, click the Tables tab, and you will find that the tables & fields are listed in alphabetical order. This makes it easier to see repeated field names, etc. as you scan the list of tables / fields.