I have converted from OpenOffice to Libre Office and a link to a database that was working is now not working. I am using the Tiger Logic Omnis ODBC connector. I can connect to my datafile correctly and see the tables but when I try and open a table I get "(SQLFetchScroll) Can only fetch the next row set" and then it says the data cannot be loaded.
Hi, There are other ODBC problems, and it looks like it is all in the OOo code which is currently shared by LibreOffice. Personally, I get a similar error "invalid cursor state" with Active Technologies proprietary ODBC driver which used to work on MacOS, there are other reports of ODBC connectivity being broken with IBM DB2 and Firebird, so it looks like something somewhere is fundamentally wrong. Clearly a regression as it all used to work on the whole pretty well :-/ The question is : where exactly is the problematic code ? The OOo base developers don't seem to be publicly very active at the moment and the LibreOffice developers are focussing on other things. So it looks like you're stuck for the moment. I would suggest a JDBC connector if you had one, but I realise that JDBC performance with OOo/LibO sucks for large datasets or cross table queries, not to mention various other problems. Alex
Could you tell us please which database you are trying to connect to ? BTW, the error you are encountering appears to be linked to LibreOffice's inability to obtain the cursor state and its properties from the driver/database. This may be due to an error in the execution of this : http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XDatabaseMetaData.html Alex
The connection is to a Tiger Logic Datafile that has been created with Omnis 4.3.1.
Setting as DUP of 32171 *** This bug has been marked as a duplicate of bug 32171 ***