To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98150 Issue #|98150 Summary|target db tables are wiped out upon connection via Uni |x ODBC within OOo 3 - Base Component|Database access Version|OOo 3.0 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|dbaneedsconfirm Reported by|floaiza
------- Additional comments from floa...@openoffice.org Fri Jan 16 15:34:50 +0000 2009 ------- OS = FEDORA 10 - GNOME OpenOffice application = Base Connection = Unix ODBC Steps: (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 ODBC. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org