Issue 124503 (XQueriesSupplier)

Summary: Dragging query from Base to a Calc sheet causes an error in Ooo 4.01
Product: Base Reporter: edknight <edknight>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3    
Version: 4.0.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows 8, 8.1   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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.