To build 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.

  1. During installation, click Yes to install sample database tables, or click the Start button, and then point to All Programs. Point to CONNX Sample Databases, and click Build SQL Server Sample Data. The SQL Server Sample Database Logon dialog box appears. Select the ODBC Provider option under Logon Information.

    image\60Install_Samp_17.gif

  2. Click the Select DSN button. The Select ODBC DSN dialog box appears. Select a DSN for the table in which the sample database is to be entered.

    image\60Install_Samp_18.gif
     

  3. Click the OK button. The SQL Server Sample Database Logon dialog box appears. Type a user name and password for the ODBC connection.

    image\60Install_Samp_20.gif

  4. Click the OK button. The sample tables are installed in the selected data source and appear in the CONNX Data Dictionary Manager window.