I try to access a Notes database using OpenOffice.org Base via the NotesSQL ODBC driver. Every request gives the correct number of result records, but the text result cells are empty. Numerical results such as from "select count(*) from my_tab;" are OK.
The very same requests using MS Access instead of OpenOffice.org Base give correct results.
Please see the corresponding bug report for OpenOffice.org: [http://www.openoffice.org/issues/show_bug.cgi?id=63415
I've expérimented this bug since OOo 2.0.3 + NotesSQL 3.0.2j to OOo 2.3 + NotesSQL 8.0.
Thanks in advance for your help.