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.