Building SQL Server ODBC Sample Database Tables
For multiple client connections to SQL Server via ODBC through a single CONNX Data Dictionary, either the SQL Server data source name must be a file-based DSN and installed on a shared network server, or the same DSN must be configured on each client computer accessing the sample database tables.
Sample database tables can be created either during installation or after installation. During installation, a dialog box appears asking whether you want to install sample database tables.
1. During installation, click Yes to install the sample database tables, or go to Start > All Programs > CONNX Sample Databases > Build SQL Server Sample Data.
2. In the SQL Server Sample Database Logon dialog box appears, select the ODBC Provider option under Logon Information.
3. Click Select DSN. In the Select ODBC DSN dialog box, select a DSN for the table in which the sample database is to be entered.
4. Click OK. In the SQL Server Sample Database Logon dialog box, enter a username and password for that ODBC provider.
5. Click OK.
The samples are installed in the selected data source table.