Views:

Product: LABEL MATRIX
Version: All Versions

Database Connection Troubleshooting

If LABEL MATRIX cannot recognize or connect to a database, an Advanced Setup connection may be required.

This procedure walks through manually creating a database connection using an OLE DB provider and ODBC data source.

NOTE: It is recommended to run LABEL MATRIX as Administrator when performing this procedure.

Important Information

If you are using .dbf files, these database files are no longer supported by Microsoft. To use them, the Visual FoxPro driver must be installed.

Converting .dbf files to Microsoft Excel or Microsoft Access format is strongly recommended when possible.

Newer versions of Microsoft Office (2013 and Microsoft 365) may not install the required OLE DB provider automatically. LABEL MATRIX commonly requires the:

Microsoft Office 12.0 Access Database Engine OLE DB Provider

Create an Advanced Database Connection

1. Launch LABEL MATRIX and select File → Label Properties.

2. Open the Database tab.

3. Click Reanalyze.

4. Select Advanced Setup and click Next.

5. Select Select an OLE DB Provider and click Next.

6. Select Microsoft OLE DB Provider for ODBC Drivers and click Next.

7. Select Advanced ODBC Selection and click Select.

Create an ODBC Data Source

8. Open the Machine Data Source tab and click New.

9. Select System Data Source and click Next.

NOTE: If LABEL MATRIX was not run as Administrator, the System Data Source option may not be available.

10. Select the appropriate ODBC driver and click Next. On the next screen, click Finish.

NOTE: This example uses an Excel ODBC driver. If no ODBC drivers are displayed, ODBC may be corrupted on the computer.

 

11. Enter a Data Source Name, optionally add a description, and click OK.

12. Select the newly created Data Source Name from the Machine Data Source tab and click OK.

Select the Database

13. Browse to the directory containing the database and select the database file. Click OK.

14. Verify the database name appears beneath Advanced ODBC Selection and click Next.

15. Select the correct database table and click Next.

16. Verify that database records are displayed correctly and click Next.

17. Choose the desired data access method and click Next.

NOTE: If you select Keyed Access, Primary, or Unlimited access, additional configuration screens will appear. Continue through the wizard and configure the primary keyed field as needed.

18. Enter a database name and optional description, then click Finish.

19. Verify the database connection appears on the Database tab and click OK.

20. Open the Data Grid and verify the database records display correctly.

Keywords: database, no compatible drivers found, no provider driver found, label matrix database driver