Connecting to an MSSQL Database
It is recommended that you use the MSSQL Enterprise Manager tool for creating and maintaining MSSQL databases.
Before you can access the tables of an MSSQL Database in a 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 MSSQL database.
To start the wizard, select Connect to MSSQL 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.