Issue 107794

Created attachment 66728 [details]
Screenshot showing problem with tables

Created attachment 66729 [details]
Screenshot showing queries are ok

Created attachment 66731 [details]
Sample database which displays this problem

*** Issue 107764 has been marked as a duplicate of this issue. ***

IMO it isn't a stopper because ODBC is one of tree possibilities to work with MySQL

@ jpmcc
Which distri do you use?

Which packages for ODBC did you install?

Did you also try the nativ mysql connector?

From the OOo-Dev Database Wizard:
Connect to an existing database -> MySQL -> Next
Connect using ODBC -> Next
Browse for the ODBC data source -> Next
Test Connection -> "Connection established successfully" -> OK -> Next
Do not register the database -> Open the database for editing -> Finish

This is on a current Ubuntu 'Karmic Koala' system, unixodbc 2.2.11-16ubuntu1,
mysql-server 5.1.37-1ubuntu5

IMO it isn't a stopper because ODBC is one of tree possibilities to work with MySQL

@ jpmcc
Which distri do you use?

Which packages for ODBC did you install?

Did you also try the nativ mysql connector?

1. there is the installation of libmyodbc missing
2. the nativ mysql connector is an extension and can be installed with the
Extension Manager
3. at http://de.openoffice.org/doc/oooauthors/odbc-datenbanken-verbinden.pdf

you find a German description how to configure the ODBC-Connection to a
mysql-Server.

I've now installed mysql-connector-ooo-1.0.0-linux-intel.oxt and when I attempt
'Test Connection' I get 

SQL Status: HY000
Error code: 2002
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

However, I don't believe extensions were ever intended as a mechanism for
providing a workround for broken code in the core product..

libmyodbc is 3.51.19r646-1

This works ok in OOo 3.1, so I think my ODBC setup is ok :-)

yes there is a error message if you try to connect to localhost but it works
nevertheless.

and I will test an ODBC connection again and report 

I can confirm that the native connector does work if you ignore the error
message and continue. However, I would expect users to give up if 'Test
Connection' returns an error...

yes the problem with "Test connection" is a know problem. As I know it is fixed
by fs.

It only appears if you connect to localhost.

This problem also affects MySQL tables used as data sources in Calc

Trying Ubuntu 9.10 (644bit) here:

ODBC connection is broken here also, as described in the issue. No table names
in any GUI view.

I can not reproduce any of the problems with the Native Connector and sockets,
seems to work for me. (but that isn't this issue, right)

Just a slight different check - instead of selecting MySQL->ODBC for the data
source I tried the other way ODBC->MySQL and the Base (OO.o) UI acts slightly
different.

With MySQL->ODBC the table items are listed with icons, so the user can see that
some number of tables exists, just can't see the names.

Using ODBC->MySQL the table section of the Base window (or any wizards that
display table objects) is completely blank. No icons with empty names, so the
user doesn't even see that there are any tables there at all.

Ok tested both scenarios (Mysql->ODBC, ODBC->MySQL) under 3.1.1 in the exact
environment as that for 3.2m_7 - no problems in Base or Calc.

Adding keyword regression
Assigning to developer

.

Fixed in cws dba32k

Please verify in cws dba32k. Thanks.

Created attachment 67026 [details]
patch

patch looks good (as far as I can judge this, with my somewhat limited expertise
in this particular area)

verified in CWS dba32k

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32k

Checked w/ XP, OOO320_RC2, MySQL ODBC Connector 5.1 (with and without the Sun 
MySQL native connector 1.0.0 installed)

Closing