Apache OpenOffice (AOO) Bugzilla – Issue 2134
crash on ODBC datasource when username not set
Last modified: 2013-08-07 15:45:14 UTC
Attempting to browse the tables of an ODBC datasource, that was created without entering anything in the "username" field, causes OO to abort with an "unrecoverable error". Entering anything (even a nonexistent username) into the username field prevents the crash. I am connecting to a PostgreSQL DB with UnixODBC under linux. The problem happens both in OO 638c and the Staroffice 6 beta. To reproduce: (install OO->workstation install; UnixODBC; create ODBC datasource"PostgreSQL") 1) in swriter, choose "Tools | Data sources ..." 2) click "New Data Source" 3) set "Database type" -> ODBC 4) for "Data source url" -> press ".." and choose ODBC datasource "PostgreSQL" 5) click "OK" to create datasource (do not enter anything under the ODBC tab!) 6) now, choose "View | Data sources" 7) expand the new data source 8) expand "Tables" Actual result: OO aborts with an "unrecoverable error". Expected result: OO should display a meaningful error message (and should not crash!). My environment: OpenOffice.org build 638c Linux kernel 2.2.19; i686 with 128 MB ram; glibc 2.1.2 (RedHat 6.1) PostgreSQL 6.5.2 (from RH 6.1) unixODBC 2.0.9 (from http://www.unixodbc.org/; compiled on RH 6.1) (contents of /etc/odbc.ini available if you want it)
Ocke, and maybe Marc may assist you, please have a look at it.
Marc: I can reproduce this issue, with an Postgresql ODBC driver. An other driver (mysql) works.
Hi, the problem was that the error code was misinterpreted. The file effected is in dba/connectivity/source/drivers/odbc/OConnection.cxx. The newest version. Regards, Ocke
Hi, fixed in OOo 1.0 Ocke
Closing now.
change subcomponent to 'none'