[Glastonbury] OOo and MySQL

[Rob Cornelius]

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
> 
>