|
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 [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] ~]$ [EMAIL PROTECTED] ~]$[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: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] Mon Apr 24 01:35:39 -0700 2006 ------- I can't reproduce it with m163. There was a bug in prior version to input data via forms. @ jeffsilv Which is the exact version number you use? --------------------------------------------------------------------- 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 Sorry I have taken so long to get back to you.To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64680 User msc changed the following: What |Old value |New value ================================================================================ Keywords| |needmoreinfo -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Mon Apr 24 00:31:50 -0700 2006 ------- Hi I can't reproduce this. Can you please give me some more information. What kind of database connection type do you use? ( HSQLDB / ODBC / JDBC /.. ) I assume that it's ODBC, right? Does the crash also occurr if you use another ODBC driver ? Bye Marc --------------------------------------------------------------------- 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 Sincerely yours Jeff Silverman |
- [www-issues] Re: [Issue 64680] ooffice base crashes (twice... Jeff Silverman
- [www-issues] Re: [Issue 64680] ooffice base crashes (... Jeff Silverman
