Building SQL Server OLE DB Sample Database Tables
The CONNX SQL Server module enables access to SQL Server database objects through the Microsoft SQL Server driver. CONNX has been tested with SQL Server 7.0 and SQL Server 2000.
SQL Server 7.0 can use OLE DB or ODBC provider connections.
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 OLEDB Provider option under Logon Information.
3. Click Select Provider. In the Data Link Properties dialog box, select a provider for the table in which the sample database is to be entered.
4. Click Next or select the Connection tab.
5. Enter a name for an SQL Server 7.0 host in which the sample database tables are to be installed.
6. Enter a username and password for the SQL Server OLE DB data source provider in item 2.
7. Select a database/catalog in item 3. If Item 3 is left blank, the default catalog for the given user is used.
8. Click Test Connection to verify that the data source is available. Click OK.
9. In the Data Link Properties dialog box, click OK to return to the SQL Server Sample Database Logon dialog box.
10. In the SQL Server Sample Database Logon dialog box, enter a username and password for CONNX.
Click OK.
The samples are installed in the selected SQL Server data source table. You can refer to the sample tables in the post-installation stage, or by opening the CONNX Data Dictionary Manager window.