Idispatch Error Message #3239 Follow

0
Avatar
Legacy Poster

I'm trying to connect to an Oracle database table that 680K+ rows in it. Using the query function I'm trying to get down to a couple hundred rows. I'm able to click on browse (in the Database Connection Setup) and enter the two prompts I have setup, but immediately after I hit ok on the prompt form I receive an error message box: BarTender: Error Message #3239. OLE has encountered error 0x80040E14: Unknown error. OLE DB error message: IDispatch error #3092

4 comments

0
Avatar
Legacy Poster
Comment actions Permalink

Now all became clear, many thanks for an explanation.
0
Avatar
Fernando Ramos Miracle
Moderator
Comment actions Permalink

Hello Brian,

1. Before adding the Queries to your document, are you able to browse without errors your database?

2. Are you adding the queries using our built in feature or are you using some sort of SQL statement?

3. Could you let me know exactly how you've configured your query? Could you attach a screenshot of the Database Connection Setup dialog with the query tab selected?

4. Could you also attach a simple label with your database connection and query already created for me to take a look at it?

Thanks!
0
Avatar
Legacy Poster
Comment actions Permalink

Hi Fernando,

Here are the answers to your questions below...

1)No and yes, I get an "Opening the records..." message box, but after waiting for a long time I get an Out of memory message (see attached image "Out of memory"), but then the records show up any way.

2)I'm adding the queries using the built in feature.

3)See attached image "Database Connection Setup - Query".

4)See attached label file "stockroom bin label - 1 inch height BR-PR-RR".

Thank you!
0
Avatar
Fernando Ramos Miracle
Moderator
Comment actions Permalink

Hello Brian,

Initially I don't see anything wrong in the actual query, but without the actual database it's hard to do any tests.

Could you send us your database (or a representative fragment of it) to the our tech support email? You'll find our contact details in the below link to our webpage:
http://www.bartenderbarcodesoftware.com/label-software/technical-support.aspx

Make sure to add a brief explanation and/or a link to this forum issue.

Many thanks!

Please sign in to leave a comment.