Bug #34287 Use of Connector/ODBC 5.1 with OpenOffice.org 2.3.1 Base crashed application

• Submitted: 4 Feb 2008 16:08
• Modified: 29 May 2008 10:04
• Reporter: Andrew Jensen
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S2 (Serious)
• Version: 5.1.4
• OS: Windows (XP SP2)
• CPU Architecture: Any

[4 Feb 2008 16:08] Andrew Jensen

Description:
Have MySQL 5.0.11 running under MS WiNXP, ODBC 5.1.1-Beta ( downloaded latest today ) and connecting to a Base file with OpenOffice.org 2.3.1 

Test connection succeeds.
Attempt to open any table via DataVeiw window in OpenOffice.org Base results in crash.

Configured driver to use myodbc.sql for errors - file remains at 0 bytes.

Using ODBC 3.51.23 with same OpenOffice.org Base file, same workstation, same MySQL database - everything works as expected.

How to repeat:
Create a new OpenOffice.org Base file with version 2.3.1 that connects to a MySQL 5.0.x database on Windows XP. In the new Database wizard select type MySQL - select connector type ODBC. Select a version 5.1.1 version of the ODBC connector.

Open the database, log in to server, change to table section in Base main window, attempt to open any table.

[4 Feb 2008 16:14] Andrew Jensen

Entered Bug report in OpenOffice.org Issue tracker - includes OO.o crash system report file.

http://qa.openoffice.org/issues/show_bug.cgi?id=85861

[15 Feb 2008 23:46] Andrew Jensen

Downloaded the 5.1.2 package and tested with OpenOffice.org 2.3.1 stable and the new 2.4 RC1 ( both under XP only ) connecting to a 5.0.45 server.

No crash - tables opened properly and so far all seems to be working.

[16 Feb 2008 19:52] Tonci Grgin

Andrew, I have come to the same conclusion after running numerous tests but on Linux (and with UnixODBC). Of course there are many things to fix/make better but I think we can close this report now. Do you agree?

[18 Feb 2008 11:27] Tonci Grgin

Tested on WinXP Pro SP2 too, no problems detected.

[18 Feb 2008 11:36] Andrew Jensen

Yes, I have had a chance to do some more with the connector and I would agree - please close this issue.

[18 Feb 2008 11:49] Tonci Grgin

Andrew, thanks again fro your report and your interest in MySQL.

Closing the report now as it appears to be fixed in 5.1.2 beta.

[18 Apr 2008 5:48] Georg Richter

According to http://dba.openoffice.org/servlets/ReadMsg?list=users&msgNo=5944 this bug wasn't fixed.

-> Reopen, P1

[18 Apr 2008 6:04] Jess Balint

Please attach ODBC trace log.

[20 Apr 2008 12:44] Tonci Grgin

Jess, Georg, who is to attach trace??? Both reporter and myself are unable to repeat this problem (thus it was closed)... If anyone can repeat this behavior or suggest what is it that I can do, please suggest.

[20 Apr 2008 13:12] Andrew Jensen

One thing I've noticed is that the person reporting the problem, in the OpenOffice.org mailing list, has installed XP Sp3 - available only since April 1st of this year. A quick read of the release notes for this service pack finds that some of the new features deal with network security - although it doesn't sound like it should interfere, I suppose anything is possible. 

I'll be installing this SP later, after system backup. Who knows maybe that will make the difference - either way I'll post up here after I've finished and tried this combination again.

[20 Apr 2008 14:33] Tonci Grgin

Andrew, many thanks for following up on this report and providing valuable info!

[21 Apr 2008 6:29] Tonci Grgin

I need someone who can repeat the crash to attach info Jess requested before proceeding...

[21 Apr 2008 6:50] Tonci Grgin

Logs/structures

Attachment: Bug34287.zip (application/x-zip-compressed, text), 14.32 KiB.

[29 May 2008 10:04] Tonci Grgin

This bug is not repeatable on any of our boxes so I'm closing it now.