Re: [libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-20 Thread Tom Davies
:) --- On Fri, 20/1/12, Alexander Thurgood wrote: From: Alexander Thurgood Subject: [libreoffice-users] Re: MySQL native connector - several databases retrieved? To: users@global.libreoffice.org Date: Friday, 20 January, 2012, 15:31 Le 20/01/12 14:35, fmayo a écrit : Hi François, > Thanks for

[libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-20 Thread Alexander Thurgood
Le 20/01/12 14:35, fmayo a écrit : Hi Frnaçois, > BTW, do you know of some guide, tuto,site or forum related to combined use of > MySQL + Base ? > Thanks again for your support in Base area. > One more thing comes to mind : to get the best out of your connection to a mysql server, you will fin

[libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-20 Thread Alexander Thurgood
Le 20/01/12 14:35, fmayo a écrit : Hi François, > Thanks for the hint, Alex. > I gave it a try, but this action did not produce any visible effect on > displayed dbs' (even with closing Base between each > action on this option). > Then, the ongoing solution for me is to have two distinct user

Re: [libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-20 Thread drew
On Fri, 2012-01-20 at 05:35 -0800, fmayo wrote: > Le 20/01/2012 09:30, Alexander Thurgood [via Document Foundation Mail > Archive] a écrit : > > If you want to be able to see all of the dbs again irrespective of the > > driver privileges, you could, instead of resetting them at mysql server > > le

Re: [libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-20 Thread Tom Davies
9c54a76bd69f7229cc http://user.services.openoffice.org/en/forum/viewtopic.php?f=40&t=41292 http://www.webhosting.uk.com/forums/mysql-hosting/5591-connecting-mysql-openoffice-base-using-jdbc.html Regards from Tom :) --- On Fri, 20/1/12, fmayo wrote: From: fmayo Subject: [libreoffice-users] Re: MySQ

[libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-20 Thread fmayo
Le 20/01/2012 09:30, Alexander Thurgood [via Document Foundation Mail Archive] a écrit : > If you want to be able to see all of the dbs again irrespective of the > driver privileges, you could, instead of resetting them at mysql server > level, try activating/deactiving the "Ignore Driver Privileg

[libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-20 Thread Alex Thurgood
Le 19/01/2012 15:05, fmayo a écrit : Hi again, Good point. I confirm that having user access privilege restricted to one single database only this one is displayed in the tables area. This seems to be a good workaround. Format: V Database name Table 1 Table 2 If you

[libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-19 Thread fmayo
Le 18/01/2012 14:37, Alexander Thurgood [via Document Foundation Mail Archive] a écrit : > If you restrict your users' rights through the Tables/Columns privilege > in mysql, are these tables still visible when you re-start LO and > re-open the ODB ? > Good point. I confirm that having user access

[libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-18 Thread Alexander Thurgood
Le 17/01/12 17:01, fmayo a écrit : Hi, > Thanks for the advice, Fernand. Good to know that it works fine with MySQL. > I tested it that way, even closing both the server and the Ubuntu session: no > change. > So, as a general info to the community, when connecting Base to MariaDB thru > MySQL

[libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-17 Thread fmayo
Le 17/01/2012 09:16, Fernand Vanrie [via Document Foundation Mail Archive] a écrit : > for MySQL it works, but maybe you have to save the odb doc, close (who > must close the connection) and reopen ? Thanks for the advice, Fernand. Good to know that it works fine with MySQL. I tested it that way,

Re: [libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-17 Thread Fernand Vanrie
Francois , for MySQL it works, but maybe you have to save the odb doc, close (who must close the connection) and reopen ? Greetz Fernand Le 16/01/2012 18:04, Fernand Vanrie a écrit : fmayo , Use the Tools >> Table Filter in the the odb document to choose the wanted -not wanted databases.

[libreoffice-users] Re: MySQL native connector - several databases retrieved?

2012-01-16 Thread Francois M
Le 16/01/2012 18:04, Fernand Vanrie a écrit : fmayo , Use the Tools >> Table Filter in the the odb document to choose the wanted -not wanted databases. Greetz Fernand Hello team, I currently installed a MariaDB base server as local host (version: : 5.3.3-MariaDB-rc-mariadb108~oneiric-log, in