Databases - Troubleshooting

Database records does not match or missing data with Excel database

Symptom BarTender is connected to an Excel spreadsheet, but the data populated on the label does not match Excel or is missing entirely such as the example shown below:  Environment BarTender Designer Diagnosis This issue is generally related to the format of the field in your Excel file. When a...
"Record Set Error": Database Connection related error message

Symptom  When opening up a label, you receive a Record Set error similar to this: Fix/Answer This error means that the database file has been moved, deleted, or is otherwise no longer at the location BarTender believes it to be. You'll need to manually correct the error. Open up the Database Set...
Oracle BarTender database connection (ODBC) slow querying records

Symptom BarTender using an Oracle ODBC database connection is slow querying and displaying records in BarTender database connection setup and when printing. It is querying from a view containing over 600,000 records. Environment BarTender v10.1 SR4 Oracle v12 ODBC driver Fix/Answer Uncheck the ...
My number is being formatted into scientific notation! How do I fix it in Excel and then BarTender?

Question I'm pulling data from Excel onto my label, but every time I do, it comes out in scientific notation. How do I fix this? Answer With long numbers from an Excel database, sometimes the label will come out like this in scientific notation: This is happening because Excel is truncating the ...
Error message 3238: Too many fields defined

Symptom When attempting to connect an Excel database, you receive the error 3238: Too many fields defined: Environment BarTender and Excel Fix/Answer  There are too many fields defined in the excel document for the database driver to handle. This can happen if you added more columns than you are...
Error 6241: A connection to the database could not be made

Symptom Error message #6241 appears at print time in BarTender Designer after moving your BarTender installation to a different computer, moving files' location, or removing files from computer. For BarTender 10.1 and earlier, the same error message is shown as #3300. Environment BarTender Desi...
BarTender not reading all desired data from an Excel cell

Symptom You have a cell within Excel that has a lot of written data in it. However, not all of it is showing up when you connect it to BarTender. It seems like the data is cut off in a multi-line text object. What is happening? Environment BarTender 2016, all Excel databases BarTender 2019 and la...
Message #6239: The Select Records dialog cannot be shown

Symptom You get the following error message in BarTender: BarTender: Error Message 6239 The select Records dialog cannot be shown due to the following: Environment BarTender Database connection Fix This message typically happens when BarTender can't properly connect to the database that y...
BarTender reading additional whitespace from database fields. Text and bar codes appear to be larger.

Symptom Text and barcode objects appear enlarged compared to previous version of BarTender (10,1 and older)  due to extra whitespaces being read. Environment BT 2016 and later Fix/Answer Set a data source transform in the object properties->transforms->truncation->trim spaces on left/right. M...
Missing columns when bringing up the "Select Record" database dialogue.

Question Why is the Select Record form missing some database fields? Answer When you click on "Select Records", (or do a Print Preview), by default, it will only show the columns for the fields used on the label. When bringing it up with no fields in use, all columns are shown. When you add a tex...
Error connecting database with Progress ODBC: "Insufficient Information to connect to the Data Source".

Symptom The following (or similar) error might appear when trying to connect to a Progress database via ODBC. “ERROR [HY000][DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source" Environment BarTender v2016 32-bits (or higher version) Prog...
Message #6670 Failed to connect to database

Symptom When using BarTender with an attached Excel Spreadsheet, you get: Error Message #6670 Failed to connect to database: unexpected error from database driver Environment BarTender 2016, all Excel database files BarTender 2019, older Excel files (.xls file type instead of .xlsx) Fix The most ...
BarTender: Error Message #3239 (0x80040E10)

Symptom BarTender: Error Message #3239 OLE DB has encountered error 0x80040E10: Environment BarTender, all versions A database connected using OLEDB drivers Fix/Answer Error 0x80040E10 states the following: "No value given for one or more required parameters." Chances are, there was a change in ...
Message #6241: A connection to the database could not be made

Symptom You receive one of the following messages when working with BarTender and Microsoft Excel: Message 6241 A connection to the database could not be made due to the following: External table is not in the expected format. Record Set Error Message: The 'Microsoft.ACE.OLEDB.12.0' Provider is N...
Database preview information not showing in Design View

Symptom When a label connected to a database file is open in design view, the database preview is not showing. Instead BarTender shows database field names or place holder information. Environment Bartender 2016 and later Professional Edition and higher Fix/Answer BarTender will attempt to show ...
Message 3201: Database field not found

Symptom You get the following error message in BarTender: Message 3201 An object on the template was set to read in the field "<field name>". However, this field was not found. Proceed with unknown fields as blank strings? Environment BarTender Designer Fix/Answer Each object in your template ha...
Error 6670 after installing Windows Updates

This article refers to a specific problem that happened in the fall of 2017. We've left this article here for historic reasons, but if you're currently experiencing Message 6670, it's unlikely that this article will help you. You should see this article instead: Error 6670 when using Microsoft Ex...
Troubleshooting Excel and BarTender

This articles applies to the following connections: - BarTender 2016, all Excel and Access connections - BarTender 2019 and later, Excel and Access connections using the older file format This article walks you through the most common errors when using Microsoft Excel. Common Error Messages He...