On 3/7/2010 2:05 PM, Rick Pasotto wrote:
Why, when I create a database connection to a specific database do I
then get presented with *all* the databases on the machine?
In trying to solve that problem I've created several redundant
connections. How do I get rid of them? Simply removing the .odb file
doesn't work. I can find no way to un-establish a connection.
Hi,
I guess we are talking the native connector.
1 ) it is a bug (but see below for details on it's severity)
2 ) you can mitigate the effect with
After setting up the connection for the first time, when the wizard
finishes for example.
Tools>Table Filter
By default all the schema (catalogs) for which the user account used to
logon with can see are selected, select only the schema (catalog) you want.
This will still leave the full list in the tables section, but only
tables in the schema(s) selected above will be displayed.
The query, form and report wizards will honor the selection also.
So lets say you are logging on as root.
You see all the schema.
But you create a user that can only see 1 schema.
Logon as that user and that is all you will see.
Regarding the connection life.
On the logon dialog you will see a checkbox in the lower right hand corner.
"Remember password until end of session"
Here session refers to the OpenOffice.org session - meaning that if you
leave that box checked then the connection will not fully die until the
last OpenOffice.org window is closed (if you have the quick starter
running this will hold it open also).
UNFORTUNATELY right now there appears to be another bug in that if you
untick that box then the connection is indeed closed when the odb file
is closed but then you can't open it again because the MySQL connector
doesn't realize it needs to pop up another logon box...arrrgh..so again
you have to close our of OO.o fully to get that to work.
Anyway - the first issue is already known and I believe being worked on
- the second problem may not be on the list yet - off to check
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
