Error: "the interface xqueriessupplier is not available

[BuschnicK]

Hello,

I have embedded a couple of queries into an OpenOffice.org 2.1 Calc spreadsheet. It works on the development machine as long as I keep the document open. If I close and reopen it I can still try to "Data->Refresh Range" but it'll produce the following error message:
"the interface xqueriessupplier is not available".

I tried opening Base in the background and connecting to the database manually - no change.

Also, If I try to open my spreadsheet on another machine (which has the exact same ODBC source installed) Office will not even offer the option of refreshing the data.

Where did I mess up? How can I embedd a database query in a spreadsheet and refresh it from any machine that has database connectivity?

regards,

Sören

[BuschnicK]

Solved: the datasource wasn't properly registered with the document. Dropping the queries again, this time from a registered source made it work.

regards,

Sören