Converting to ODBC
Database Builder provides a wizard for converting tables into an ODBC database from any other supported database type. This wizard will convert the table structures from the current workspace's database into an ODBC database and then move all of the data.
To convert tables from the current workspace's database into an ODBC database, select Convert to ODBC from the Database menu. This brings up the Conversion Wizard. Press Next, and the Select Source Tables page will be displayed, where you should select the tables that you wish to convert.
The checkbox above the list of tables – Delete original table after conversion of table successfully completed – should be selected if you would like to delete the original tables after successful conversion. If any errors occur during conversion, the original tables will not be removed regardless of the selection you make here. Once you have selected the tables, click the Next button so the wizard analyzes the selected tables. Click on Next again to continue with the conversion options.
For recnum tables, the Define Recnum Table Conversion page will be displayed, listing all the tables identified as recnum tables. The checkbox Convert recnum tables to standard tables lets you choose whether you want to keep the table as a recnum table or not. If you choose to convert the tables to standard tables, you will need to select the indexes for all the tables listed.
After that, click on Next to move on to the Define Conversion Options page. On that page, enter the following:
Data Source
Enter the data source names (DSN) of the data source you are connecting to. The prompt button activates a pick list of system and user DSNs.
Login ID
Enter the user name to use for authentication when you log on to the database.
Password
Enter the password for your user name.
Schema
Enter the name of the table schema to be used for the tables being converted.
Show User Data Sources
Check this option to display all your user DSNs in the Data Source combo box.
Show System Data Sources
Check this option to display all your system DSNs in the Data Source combo box.
Store Data in ANSI Format
This option sets the table character format of the resulting table. If checked, data will be stored in ANSI format. If not checked, data will be stored in OEM format.
File DSN
Click on this button to select the file (.DSN) where the data source is specified.