To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64680
------- Additional comments from [EMAIL PROTECTED] Sun Apr 30 22:07:39 -0700 2006 ------- Here is the procedure I use to connect to the database. Start OpenOffice (ooffice). File -> New -> database . Select Connect to an existing database using ODBC. Use MySQL-equipment_test as the data source name (note that this comes from the /etc/odbc.ini file). Enter the username, and turn on the password required checkbox if needed. Since the equipment_test database allows anonymous read/only access, this step is optional. Click on the test database button, and it should say that it connected successfully. Register the database, which creates a file so you can do this faster next time. Click on edit tables if you want to edit the tables. To reproduce the problem: go through the procedure above. Then, click on the create table in design view, design a table, and click on the save icon and it crashes. When I restart openoffice base, it goes through the recovery process fine. I also tried: File -> New -> database . Select Connect to an existing database using MySQL. Click on NEXT. Select ODBC. Click on Browse. Select MySQL_equipment_test. It wants a user name, enter root select password required. Select register the database. Select open database for editing. Again, click on the create table in design view, design a table, and click on the save icon and it crashes. I tried using JDBC, but it won't open the JDBC driver (probably because I haven't installed it yet - I need to go back and read the manual). I am using OpenOffice 2.0 from RedHat Fedora Core 4. [EMAIL PROTECTED] ~]$ rpm -q --file /usr/bin/oobase openoffice.org-core-2.0.1.1-5.1 [EMAIL PROTECTED] ~]$ rpm -q -a | fgrep openoffice openoffice.org-calc-2.0.1.1-5.1 openoffice.org-javafilter-2.0.1.1-5.1 openoffice.org-core-2.0.1.1-5.1 openoffice.org-debuginfo-2.0.1.1-5.1 openoffice.org-impress-2.0.1.1-5.1 openoffice.org-math-2.0.1.1-5.1 openoffice.org-xsltfilter-2.0.1.1-5.1 openoffice.org-pyuno-2.0.1.1-5.1 openoffice.org-graphicfilter-2.0.1.1-5.1 openoffice.org-writer-2.0.1.1-5.1 openoffice.org-testtools-2.0.1.1-5.1 openoffice.org-draw-2.0.1.1-5.1 [EMAIL PROTECTED] ~]$ uname -a Linux black 2.6.14-1.1656_FC4 #1 Thu Jan 5 22:13:22 EST 2006 i686 athlon i386 GNU/Linux Here is my odbc.ini file contents: [MySQL-test] Description = MySQL database test Driver = MySQL Server = localhost Database = test Port = 3306 [MySQL-equipment_dev] Description = MySQL equipment database development Driver = MySQL Server = black.commercialventvac.com Database = equipment_dev Port = 3306 [MySQL-equipment_test] Description = MySQL equipment database test Driver = MySQL Server = black.commercialventvac.com Database = equipment_test Port = 3306 [EMAIL PROTECTED] ~]$ more /etc/odbcinst.ini # Example driver definitinions # # # Included in the unixODBC package #[PostgreSQL] #Description = ODBC for PostgreSQL #Driver = /usr/lib/libodbcpsql.so #Setup = /usr/lib/libodbcpsqlS.so #FileUsage = 1 # Driver from the MyODBC package # Setup from the unixODBC package [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libodbcmyS.so FileUsage = 1 [EMAIL PROTECTED] ~]$ ls -l /usr/lib/libodbcmy* lrwxrwxrwx 1 root root 19 Jan 16 04:49 /usr/lib/libodbcmyS.so -> libodbcmyS.so.1.0.0 lrwxrwxrwx 1 root root 19 Jan 16 04:49 /usr/lib/libodbcmyS.so.1 -> libodbcmyS.so.1.0.0 -rwxr-xr-x 1 root root 6252 Sep 30 2005 /usr/lib/libodbcmyS.so.1.0.0 [EMAIL PROTECTED] ~]$ rpm -q --file /usr/lib/libodbcmy* unixODBC-2.2.11-3.FC4.1 unixODBC-2.2.11-3.FC4.1 unixODBC-2.2.11-3.FC4.1 [EMAIL PROTECTED] ~]$ --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
