Views:

Product: LABELVIEW, CODESOFT

Version: All Versions

 

OLEDB connections to dBase (.dbf) file formats must be created manually, as a wizard does not exist for this older database file type. To manually create the OLE connection, follow the steps below.

 

1. Navigate to Tools > Administrator OLE DB.

2. Click the New button.

3. From the Provider tab, choose Microsoft Jet 4.0 OLE DB Provider. Click Next.

4. From the Connection tab, enter the path to the directory that contains the dBase file that you'd like to connect to. This path must be entered in manually, so do not use the browse button. It is important to note that you are not defining the file itself but the directory that contains the dBase file. 

5. Click on the All tab. Select Extended Properties and click the Edit Value button.

6. Enter dBase IV in the Property Value field. Click OK.

7. Name the Connection. Click OK.

8. Your new connection will be viewable in the Connections list of the Administrator OLE DB window. Click OK.

9. From the Data Sources pop-out or the Data Sources drop-down, select Create/Edit query.

10. Click the Select a data source drop-down and choose the new connection.

11. Select the table where the data is that the label needs to pull from.

12. Lastly, Select the fields you'd like to include on the label. Click OK.

The dBase file should now be connected and show in the Data sources pop-out or in the Data source drop-down tree. Now you'll be able to place the database variables on your label. 

 

Keywords: OLE to dBASE, .dbf database, .dbf database connection, labelview .dbf connection, codesoft .dbf connection, legacy .dbf file