Well, as above, when adding a datasource, OO fails to find libodbc.so.1 which is not in programs directory of OO; there is a libodbc2.so. Reproducible: Always Steps to Reproduce: 1. Install OO 2. Go to Tools -> Data Sources 3. Change the database type to MySQL 4. Select "Use existing MyODBC data source" & Click on the button "..."
I assume this only shows up if I really have a mysql source somewhere, cause just following your steps nothing happens for me. Correct?
I have a ODBC data source: $ cat /etc/unixODBC/odbc.ini [MySQL-mysql] Description = MySQL database mysql Driver = MySQL Server = <myhostname> Database = mysql Port = 3306 $ cat /etc/unixODBC/odbcinst.ini [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc3.so FileUsage = 1 I'm just trying to connect to the internal database, which I can do using the isql command. Basically, I cannot connect to the MySQL database at all. I can't use the unixODBC driver, or the MySQL ODBC driver, I can't use the JDBC driver as it won't remember/use sun-j2sdk-1.4.2. If I press the "Organize..." button in the "Data Source" window, it gives me the following message: "Could not load the program library libodbcinst.so or it is corrupted. The ODBC data source configuration is not available." Firstly, OO should emerge the necessary packages, it doesn't. Then it doesn't even work. I can't think of any other steps, as those are the ones that cause the problem for me. I can upload some screen shots if you'd like to see what happens? Luke.
For the whole "Not working" stuff, take a look at: http://bugs.gentoo.org/show_bug.cgi?id=69943 Is that helpful?
Yeah, that seems to be the same problem. Although the fact that OO still can't use sun-j2sdk-1.4.2 is still a problem, and yes, I did re-emerge OO.
I don't know about the ximian version, but for the normal version, odbc is like jdbc optional at runtime. This libodbc.so.1 library is provided by unixODBC, and openoffice will use it when available.
It doesn't though. I have them installed
At my system /usr/lib/libODBC.so.1 is provided by dev-db/unixODBC-2.2.8, could you see whether you have that too? It seems that your odbc installation is somewhat broken. Do you have "gODBCConfig" and do you have data resources setup? (this is nontrivial, but not related to openoffice)
dev-db/unixODBC Latest version available: 2.2.6 Latest version installed: 2.2.6 I have /usr/lib/libodbc.so.1 not libODBC* There are other problems with the Ximian version, so I'm gonna try the beta of OO 2 and then install whatever normal OO version there is if that doesn't work.
What "other" problems do you have with the ximian version (which are not in the vanilla OOo)? Cause actually, I don't believe these are -ximian specific...
I cannot get it to recognise fonts that I have installed under GNOME - these work in GIMP and the font selector. They just don't show up in OO. I've already mentioned the Java problem in a previous post here. The manual says that you can install fonts via spadmin, you cannot.
Well, I've just tried out the plain openoffice.org1.9.69 and it just doesn't make sense, at least Ximian got one thing right; make the thing more intuitive!! The best thing the OO people could do is to fold in the changes that Ximian made. Fonts look bloody awful! When I exported a drawing which had some text on, the text messed up...oh well.
Fonts in ooo-ximian are autodetected, no need anymore for spadmin. If it doesn't work for you, this is a problem with your font setup
So how come they're detected within GNOME then? I can see them in the fonts drawer, I can use them in the fonts preferences, I can use them within GIMP-2.0. There's something wrong with OO.
As Paul already pointed out unixODBC is an optional dependency, so won't fix this. About your other problems, you could try to redo your user install dir, as it works for me (and others), it has to be a local problem.
I already deleted my .xopenoffice directory, nothing.
It was a typo from me, Indeed my libodbc is in small case, not uppercase. Leaves the check that unixODBC is configured correctly. To access a datasource with openoffice, it first must be configured well for unixODBC. This cannot be done by openoffice.
*** Bug 134046 has been marked as a duplicate of this bug. ***