KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Tips on using the ODBC Driver for 4D Server
PRODUCT: 4D | VERSION: | PLATFORM:
Published On: April 30, 1999
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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.