Comment 0 for bug 123307

Binary package hint: openoffice.org-base

I just installed the latest Ubuntu on a system which used to have SuSE 10.1 on it, and which was able to use OpenOffice to connect to all of my business database tables. The database server is MySQL 5.0.32. I can open all of my tables except one, and when I try to open that table, I get the error message: "The data content could not be loaded ... [unixODBC][Driver Manager]Invalid cursor state." Sometimes (but not every time) OO.org crashes after the error dialog is dismissed. The table has a primary key (compound, with three columns). The bug I found which was closest to this bug does not appear to be the same problem, as the filer of that bug says that his problem goes away when he switches from the 64-bit version to the 32-bit version, and I'm running 32-bit versions of everything on this machine. I've been using these tables for almost a decade now, and the structure hasn't changed since the tables were created. This worked fine under SuSE (and still does on another machine I just upgraded to SuSE 10.2), and it worked fine before that when the client machine was running Fedora.

To reproduce:

* Install the latest Ubuntu i386
* Add mysql, unixodbc and libmyodbc packages
* Create a mysql database
* Create the following table:

CREATE TABLE ubuntu_repro
          (a DATE NOT NULL,
           b DECIMAL(8, 2) NOT NULL,
           c VARCHAR(50) NOT NULL,
CONSTRAINT repro_pk PRIMARY KEY (a, b, c));

* Create a DSN in odbc.ini for connecting to the database
* Open OO.o base
* Connect to the database via ODBC
* Try to open the table

Relevant version numbers:
openoffice.org-base 2.2.0-1ubuntu3
libmyodbc 3.51.11-6
unixodbc 2.2.11-13

Any other version number (or any other information) needed?