Using EASYLABEL and an MS-EXCEL Open Database Connectivity (ODBC) Driver


The purpose of this document is to provide troubleshooting information when using an ODBC driver with EASYLABEL.

Section I. Identifies some common issues that pertain to the ODBC driver setup.
Section II.Identifies some common issues that pertain to EASYLABEL and connection to the data file specified in the ODBC driver setup.

I. Common issues pertaining to the ODBC driver setup.

Symptom:
Data Source Name is not listed in EASYLABEL’s “DATABASE SYSTEM” selection box.

Common Causes:
– the ODBC driver is not installed.
– the ODBC driver is installed; however the path for the data source is incorrect.

Symptom:
The data file name is not listed in EASYLABEL’s “TABLE NAME” selection box.

Common Causes:
– the ODBC driver version is incompatible with the application version
– the path in the ODBC driver setup is incorrect.
– the data file is already open and the ODBC driver cannot display an open file.

Symptom:
EASYLABEL cannot display the field names.

Common Causes:
– if there are any index files associated with the data file, the index files may be corrupt.
– the data file may be corrupt.

II. Issues regarding EASYLABEL and the data file.

Problem:
When attempting to connect to an MS-Excel file, an ‘Invalid File Access’ message is displayed.

Cause:
The Microsoft Excel ODBC driver is not able to read Microsoft Excel files whose format is earlier than version 3.0. The ODBC driver is able to read MS-Excel files that were created in MS-Excel version 3.0, 4.0 or 5.0.

Solution:
MS-Excel files created under versions earlier than 3.0 should be opened in a later release of Microsoft Excel and saved in version 3, 4, or 5 format.

Problem:
Customer has configured an Excel ODBC driver to read an Excel 5.0 Workbook file. The following message appears when trying to select the Excel file for the File Name screen item:

Syntax Error in from clause

Cause:
The ODBC driver being used is the Microsoft Excel ODBC Driver Version 2.0 and the driver is setup to read an MS-Excel 5.0 workbook file. This version has a bug and cannot recognize Excel 5.0 or 5.0c files.

Solution:
There are two solutions:
1) An ODBC Query Driver is automatically shipped with Excel 5.0 and higher. This is the driver that should be used.
2) If using the MS-Excel 2.0 ODBC driver, make sure that the driver is setup to read Excel 4.0 worksheet files. Also, make sure that the Excel file is saved as an Excel 4.0 worksheet file.

Problem:
Customer has configured an Excel ODBC driver to read an Excel 4.0 Worksheet file. The following message appears when trying to select the Excel file for the File Name screen item:

Couldn’t find object (‘unknown’)

Cause:
The ODBC driver being used is the Microsoft Excel ODBC Driver Version 2.0 and the driver is setup to read an MS-Excel 4.0 worksheet file. The MS-Excel file was actually created under MS-Excel version 5.0 and saved as a Workbook file.

Solution:
Open the Excel file under version 5.0 and save the file as an Excel 4.0 worksheet file.