[Glastonbury] OOo and MySQL

[Rick Fitzsimmons]

I've heard that Rekall does what you're looking for (on multiple 
platforms too). I've not tried it myself yet, but hope to soon.

Try looking at http://www.totalrekall.co.uk/ for the GPL version, or 
http://thekompany.com/products/rekall/ for the commercial version.
Or even http://www.rekallrevealed.org for the source code.

I'd be interested in progress with OOo too, as MySql integration with 
OOo is something else I've been meaning to look at.

Cheers,
Rick.


Rob Cornelius wrote:

> Wotcha
> 
> Bit of a crossed line here OOo is OpenOffice(.org). I use phpMyAdmin or 
> sqlYog as a front end for MySQL myself been using MySQL for years now 
> since verson 3.1.something.
> 
> But one of the companies I work for had a 2million record database in 
> Access that took up to a couple of hours to get any data out of. So I 
> replaced it with MySQL and they can get the same data in milliseconds 
> (ok so its on a dual Xenon server now but hey).
> 
> The problem is that the people who work there have about 3 sessions at 
> night school doing CLAIT between them. Therefore the only database front 
> end they can use is Access. (I go there and type queries into the mysql 
> command line and they refuse to believe the results I get out) They 
> wouldn't know a select statement if it bit them.
> 
> Then the boss there says "this linux thing you use is cheap isnt it?" 
> (the server is on RH9) So I have to set up a linux workstation..... So i 
> need a database front end that is as much like access as possible.... 
> THe only one I know of at all for linux with a "point and click, drag 
> and drop" query designer is Open Office. Hence my predicament.
> 
> This is a real "if I can get linux/OSS accepted here we can conquor the 
> world situation" So far they agree that KDE looks pretty.....
> 
> Rob
> 
> Sean Miller wrote:
> 
>>> Hi everyone,
>>>
>>> I have spent a very frustrating afternoon trying to get OOo to connect
>>> to a MySQL server on another machine.
>>>
>>> I need something that "Just like Access" to keep my boss happy (and more
>>> important the person working on the database who last learned a new
>>> skill in 1995! OOo seems ideal and the screenshots of the database
>>> component in action look great.
>>>
>>> I have tried everything I can think of in the "add datasource" dialog.
>>> Either I get a message to say I typed in my username and password wrong
>>> or occasionally I get a message to say a so file is corrupt! The help
>>> basically says "fill out the fields in the dialog" and I have been all
>>> over Google.
>>>
>>> I tried both the MySQL direct method and ODBC but both with the same
>>> results.
>>
>>
>>
>> I do not know OOo what is it?
>>
>> There are plenty of MySQL front ends out there... I do not know how 
>> Access
>> works (have managed to avoid it) so do not know why you seem to
>> anti-MySQLFront or phpMyAdmin etc. etc.
>>
>> Can you provide a list of requirements and I can see if I can find you a
>> tool that will enable all your wildest dreams and (who knows) maybe 
>> dreams
>> you didn't even realise you could have dreamt ?  Please take it from 
>> me that
>> MySQL blows Microsoft Access away in *EVERY* way... I work full time 
>> using
>> Oracle, have done for best part of 20 years now, but MySQL is becoming a
>> language to be reckoned with.... I downloaded MySQL 5 beta the other 
>> day and
>> it is breathtaking....
>>
>> Even if your colleague has to spent half an hour out of his drinking time
>> learning a new front end, it will be worth it... MySQL/Microsoft?!?! It's
>> like comparing a fine vintage wine with the home brew kits in Hallets....
>>
>> Sean
>>
>>
>> _______________________________________________
>> Glastonbury mailing list
>> Glastonbury at mailman.lug.org.uk
>> http://mailman.lug.org.uk/mailman/listinfo/glastonbury
>>
>>
> 
> 
> _______________________________________________
> Glastonbury mailing list
> Glastonbury at mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/glastonbury
> 
>