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

 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.
> >
> > Greetz
> >
> > Fernand
> > > Hello team,
> > > I currently installed a MariaDB base server as local host (version: :
> > > 5.3.3-MariaDB-rc-mariadb108~oneiric-log, installed from deb 
> > > repositories)
> > > and would like to connect it with LO as a GUI (Tom would likely to
> > > appreciate.....)
> > > For this, I installed the MySQL connector plug-in
> > > ('mysql-connector-ooo-1.0.1-linux-x86_64.oxt').
> > > Connection set up: one existing database specified (this one being
> > > completely empty) - with a user name having all rights on all 
> > > databases in
> > > this context.
> > > Well, the connection worked fine, except that ALL existing MariaDB 
> > > databases
> > > got displayed in the table section, instead of the single one 
> > > specified in
> > > the connection set up; corresponding tables are listed below each db 
> > > name.
> > > I suppose that this was not the expected result ans I'm doubtful about
> > > accessing simultaneously to all tables within all db.
> > > Then the question is: what did I wrongly? How could I correct this, 
> > > please?
> > > I didn't go any further, for instance I did not test with a user having
> > > access right only defined for the target db.
> > > Thanks in advance for any hint or highlight!
> > > (LO version in the signature)
> > >
> > > -----
> > > Francois
> > > Dualboot Ubuntu 11.10 amd64 - W7
> > > LibreOffice 3.4.4 OOO340m1 (Build:402)
> > > --
> > > View this message in context:
> > > http://nabble.documentfoundation.org/MySQL-native-connector-several-databases-retrieved-tp3663736p3663736.html 
> > >
> > > Sent from the Users mailing list archive at Nabble.com.
>
> Thanks very much for a so quick answer and guide line, Fernand.
> Tried it, but this did not change displayed db/tables in any way (even 
> after switching forth and back to queries or forms).


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted