1. Home
  2. Labeling Software
  3. BarTender - Seagull Scientific
  4. BarTender Problems
  5. “BarTender: Error Message #3239 – OLE DB has encountered error 0x80040E14: Unknown error. OLE DB error message: IDispatch error #3092” – BarTender Error Message

“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

Updated on July 30, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support