On Tuesday 18 June 2002 8:31 pm, you wrote:
Presumably you wish to explore OpenOffice's ability to connect to a MySQL db, a la Access. If you are not already using the excellent and high-quality howto from OpenOffice, written by John McCreesh , can I suggest that you download that first (2.1Mb PDF) from www.unixodbc.org/doc/.
Yup, that's what I want, and that's where I started.
Richard had a very cunning way of getting at MyODBC, but unless there is some way to pull it out of the package, it would probably be faster to download it direct from the MySQL site (it's only 226Kb) - the RH rpm v2.50.39-1 will do. This installs into /usr/local/lib, whereas the rest of
Yup, that's what I did. The RH RPM went in without fuss.
Next, install the package unixODBC-gui-qt, which is on the disks (unixODBC
I never found that package on my SuSE-8.0 disks. I did my config using the text files. Now you've named it specifically, I've installed it, though it's a bit late now. :)
Thereafter, just follow the howto. All in all, the OO/SOfunctionality is very impressive
I'm not sure what I was expecting since I've never seen Access. The last database front end I worked with was dBase, years ago. I got the OO/unixODBC working when I'd figured out the OBDC issues, but the OO interface doesn't seem to work properly. I run a simple query to list a single field from all the records of a table. The list shows records "1 of 38", even though there's 285 rows in the table. Paging down seems to pull in a few more records each time. Is this normal? Also, filters. I click the default filter and set up "Procedure = 'Accept'", then click OK. The dialog box disappears, but nothing else happens. I'd expect to be left looking at a single record, but they're all still there. I've been ignored. I pull up the default filter dialog again and what I entered has disappeared - it's all back to the default values. Basically, it doesn't seem to work. Am I doing something wrong? -- There are 10 types of people: those who understand binary, and those who don't