This dialog is used to help form a connection string to a non-Managed database via ODBC.
Enter the data source names (DSN) of the data source you are connecting to. The combo list displays all the available data sources on your machine according to the filters specified below
Filters the data source combo list to data sources that are local to a computer and accessible only by the current user.
Filters the data source combo list to system data sources.
Activates the open file dialog to select a data source that is specified inside a file (.dsn).
Enter the user name to use for authentication when you log on to the database.
Enter the password for your user name.
Click the ODBC Administrator button to launch the ODBC Administrator application.
Click the Test Connection button to test the connection properties that you have entered. Database Builder will attempt to connect to the database using these settings. If a connection is established, then a 'success' message will be displayed. If the connection fails, then an error is displayed showing the full connection string that was used.
Click the Make Default button to make the connection settings in this dialog the new default connection settings for the current workspace.
Click OK to use the entered connection properties to form the connection string for the new table that you are creating.
Click Cancel to close this dialog without using the entered connection properties.