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:	code	Assignee:	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, https://issues.apache.org/ooo/show_bug.cgi?id=119147 , 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.