Building 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.
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.
The driver used to import table information must support ADO and be fully ODBC Level 2 compliant.
1. During installation, click Yes to install the sample database tables, or go to Start > All Programs > CONNX Sample Databases > Build Desktop OLEDB Sample Data.
2. In the Desktop OLEDB 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 an OLE DB provider from the list.
Click 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.
4. In the Connection tab, enter an OLE DB data source or click the Browse button ... to locate a suitable data source for insertion of the sample data.
Click Test Connection to verify that the data source is available. Click OK.
5. Click OK to return to the OLEDB Desktop Sample Database Logon dialog box.
6. In the Desktop 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.