Public bug reported:
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?
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
--
OpenOffice fails to open odbc table with compound primary key
https://bugs.launchpad.net/bugs/123307
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
