Connecting to an ODBC Database
It is recommended that you use the native database tools for creating and maintaining SQL databases.
Before you can access the tables of an SQL Database via ODBC in your Workspace, you will need to create table descriptions. Table descriptions are stored in .INT files in the workspace's Data folder. One .INT file is maintained for each table that you will use in the workspace.
Database Builder contains a wizard that can build these .INT files for you. This is the recommended way to describe your connection to an SQL database via ODBC.
To start the wizard, select Connect to ODBC Database from the Database menu. Follow the wizard prompts on each page to complete the connection.
Updating the Table Descriptions
Each time that a database is modified (e.g., a table structure is changed, or a new table is added), you should run the connection wizard to import the necessary changes into the DataFlex table descriptions.