Issue 124503 (XQueriesSupplier) - Dragging query from Base to a Calc sheet causes an error in Ooo 4.01
Summary: Dragging query from Base to a Calc sheet causes an error in Ooo 4.01
Alias: XQueriesSupplier
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.0.1
Hardware: PC Windows 8, 8.1
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-03-24 23:38 UTC by edknight
Modified: 2014-03-24 23:38 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description edknight 2014-03-24 23:38:27 UTC
This bug report is similar to the one posted here, , except that report was for OOo 3.4.  While 3.4 may have been fixed, OOo 4.01 still has a similar issue.  I'm not an IT tech guy, but here's my report.

I've recently had to reformat my C:\ Drive, reinstall win 8 (x64). In the process, I switched from OOo 3.4.1 to OOo 4.0.1. Java is
7.0.510.13 My OOo DB is a split using server mode using Mydb.exe. Data mods using forms works OK after pointing OOo and the server.start.bat files to new locations for Java.exe and hsqldb.jar. My problem happens when I try to export a query by dragging to an OOo Calc sheet. I get the error below.

"The interface XQueriesSupplier is not available"

My Base connection checks...The following are listed under my OOo's Registered Databases: biblio.odb; mydb.file.odb; EKP_Inventory.file.odb (This is the name of my DB). Under Edit/Database/Database Properties DB Type is "JDBC". Under Connection settings, both Test Class and Test Connection buttons showed "successful".

Results of my tests of dragging a query to a Calc sheet.  

OOo 3/Mydb

Win 8 (x64) OOo 3.4.1 - Dragging Successful
Win XP SP3 (x32) OOo 3.3.0 - Dragging Successful

OOo 4.01/Mydb

Win 8 (x64) - Dragging caused Error above
Win XP SP3 (x32) - Dragging caused Error above

Thus, it appears the problem is with OOo 4/Mydb. My guess is that it is a bug as a copy/paste of the query works, while dragging throws an error.