Issue 98150 - target db tables are wiped out upon connection via Unix ODBC within OOo 3 - Base
Summary: target db tables are wiped out upon connection via Unix ODBC within OOo 3 - Base
Alias: None
Product: Base
Classification: Application
Component: ReportBuilder (show other issues)
Version: OOo 3.0
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2009-01-16 15:34 UTC by floaiza
Modified: 2013-02-02 02:58 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description floaiza 2009-01-16 15:34:50 UTC
OpenOffice application = Base
Connection = Unix ODBC


(1) Connect to Mysql and create a new target database running the corresponding
SQL script.

(2) Check the target db created in Step (1), e.g., execute "show tables"
command. Result shows all the tables have been successfully created.

(2) Create the ODBC connection using "ODBC Data Source Administrator" (the rpms
for the libraries required are those from MySQL website)

(3) Launch OpenOffice Base and create a database from an existing source. Select
ODBC and enter the user and pswd; test connection, and finish.

(4) Interface shows the database objects with "Forms" selected. Clicking on
Tables does not refresh the display, i.e., no tables are shown.

(5) Go back to MySQL and from the command line connect to the target db. 

(6) Execute "show tables" command. Now no tables are shown. This appears to be
the result of having connected with Open Office 3 Base to the target db via Unix
Comment 1 Mechtilde 2009-05-31 20:55:30 UTC
do you edit ~/.odbc.ini
what is the entry in /etc/odbcinst.ini

do you also try JDBC?
Comment 2 Rob Weir 2013-02-02 02:58:55 UTC
This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the