I have a problem similar to wht has been reported with mysql ODBC
access : immediate crash of OpenOffice Base when trying to query a
PostgreSQL ODBC database.
Setup : Hardy (8.04) amd64 + updates from hardy-updates and
hardy-backports. OpenOffice-base is 1:2.4.1-1ubuntu2, PostgreSQL is
8.3.3-0ubuntu0.8.04 (sic... that's what dpkg - reports) and
odbc-postgresql is 1:08.01.0200-2.1. unixodbc is 1:08.01.0200-2.1. All
of this comes clean from Ubuntu repositories.
Way to reproduce : create test database (with psql or with OOo and the
the SDBC driver), crete a test table. Check it with various tools (OOo +
SDBC in my case), check the ODBC connection (I tested with isql and R +
RODBC) : works like a charm.
In OOo, create a new database file accessing the test database via the
ODBC driver. runs OK, asking (correctly) for the database's password.
The "Tables" views shows the "public" schema and the test table. Click
on the table's name (or icon) : immediate crash. Relaunching OOo-Base
leads to the "restoration of an unsaved document", which runs OK. An
you're back where you started.
Other symptoms : trying to create a query crashes as soon as you are
trying to click on the table's name or icon. You can create a query in
SQL mode, but trying to execute it crashes immediately.
In short, the &[EMAIL PROTECTED] OOo-base crashes as soon as it tries to get
information about a table.
I have had similar symptoms with a sqlite3 database, but I concluded
(erroneously ?) that this might be an ODBC driver problem (the
libsqlite-odbc package seems to be a bit ancient when compared to
upstream...). Now, it seems to me that the problem might lie with
OOo-base (amd64) trying to access a table in the "public" schema.
Attached is an ODBC trace coresponding to the following operations :
- open OOo-base
- connect to the database,
- clicking (once) on the table name in the "tables" view.
[ Crash ]
Sincerely yours,
Emmanuel Charpentier
** Attachment added: "sql.log.gz"
http://launchpadlibrarian.net/17031250/sql.log.gz
--
Crash on odbc traffic with MySQL server
https://bugs.launchpad.net/bugs/219206
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
