Building Enterprise OLE DB Sample Database Tables
The Enterprise version of the OLEDB/ODBC Adapter Module can be used to access data from any existing third-party ODBC or OLE DB data source, including IDMS, Ingres, UniVerse, Unidata, or IMS data sources. The following procedure runs a script designed to insert CONNX sample data into an OLE DB database provider installed on the client machine.
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 Enterprise OLEDB Sample Data.
2. In the Enterprise OLEDB Sample Database Logon dialog box appears, select the OLEDB Provider option under Logon Information.
3. Click the Select Provider button.
4. In the Data Link Properties dialog box, select an OLE DB provider from the list.
5. Select the Connection tab. Each OLE DB provider may have a unique dialog on this tab. All will require a data source or database name and possibly user and password entries.
Click Test Connection to verify that the data source is available. Click OK.
6. In the Enterprise OLE DB Sample Database Logon dialog box, enter a user name and password for the OLE DB provider. Click OK.
The samples are installed in the selected data source table. You can refer to the sample tables in the post-installation stage, or by opening the CONNX Data Dictionary Manager window.