To build Desktop OLE DB sample database tables

The Desktop version of the OLEDB/ODBC Adapter can be used to provide read/write access to data sources normally stored on the desktop, in a hard drive, or on a network drive, including Paradox, FileMaker, FoxPro, Lotus Notes, dbase, and Microsoft Access in database format. Refer to the CONNX User Reference Guide, either online, on the CD-ROM, or in hard copy, for more information on the text boxes required for building sample tables.

The following procedure runs a script designed to insert CONNX sample data into an OLE DB database provider installed on the client machine. For information on how to install sample data into an ODBC database, see To Build Desktop ODBC 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. Click Yes to continue with sample table installation through CONNX sample database logon dialog boxes. Click No to continue with CONNX installation. You can install sample tables at any time using the Build Sample Database icons available in your program group.

 

Important: The driver used to import table information must support ADO and be fully ODBC Level 2 compliant.

  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 Desktop OLEDB Sample Data. The Desktop OLEDB Sample Database Logon dialog box appears. Select the OLEDB Provider option under Logon Information.

    image\Image3.gif

  2. Click the Select Provider button.

  3. The Data Link Properties dialog box appears. Select an OLE DB provider from the list. In this example, Microsoft Access (Jet 3.51) provider is used.

    image\60Install_Samp_19.gif

  4. Click the Next button or select the Connection tab. Each OLE DB provider may have a unique dialog on this tab. All require a data source or database name and possibly user name and password entries. Consult documentation for each provider for specific access requirements.

  5. Enter an OLE DB data source or click the Browse button (...) to locate a suitable data source for insertion of the sample data.

    image\60Install_Samp_12.gif

  6. Click the Test Connection button to verify that the data source is available. Click the OK button.

  7. The Data Link Properties window appears. Click the OK button to return to the OLEDB Desktop Sample Database Logon dialog box.

  8. The Desktop OLE DB Sample Database Logon dialog box appears. Type a user name and password for the OLE DB provider, and then click the OK button.

  9. The samples are installed in the selected data source table and appear in the CONNX Data Dictionary Manager window.