“BarTender: Error Message #3239 – OLE DB has encountered error 0x80040E14: Unknown error. OLE DB error message: IDispatch error #3092” – BarTender Error Message

Summary

This article explains the BarTender error message “BarTender: Error Message #3239 – OLE DB has encountered error 0x80040E14: Unknown error. OLE DB error message: IDispatch error #3092” and details how to fix the underlying problem that caused it to appear.

Explanation

BarTender is executing an invalid SELECT or WHERE. This message appears when opening a BarTender file that has an existing database connection to a database that has been changed. The database change makes the previously valid SELECT or WHERE statements invalid. The same error has been seen both with:

1) Custom SQL statements

2) SQL statement created by the Database Connection Setup wizard

Solution

Correction of the incorrect SELECT statement (i.e. tables referenced were no longer valid) either by changing the custom query or disconnecting the database connection and rerunning the wizard made the error disappear.

Additional Comments

Issue Found On:

Windows 8, BarTender v10.1

Related Articles:

BarTender Problem Article: KBA-01169-X4Y3C0 – Invalid Custom SQL Queries in BarTender

Author

---

Related Articles

• Loftware Redirect Print to PDF action using multiple printer seats
• License is failed – TEKLYNX CENTRAL Error Message
• Loftware Web Designer vs Desktop Designer
• Loftware Workday API Splitting Print Jobs
• Planning a BarTender Server Migration and Upgrade – BarTender Instructions Article
• Deciding on an In-Place Upgrade, Test Server, or Migration – BarTender Reference Article