<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Suggested database connection string parameters incorrect in URL entry dialog"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126624#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Suggested database connection string parameters incorrect in URL entry dialog"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126624">bug 126624</a>
from <span class="vcard"><a class="email" href="mailto:lionel@mamane.lu" title="Lionel Elie Mamane <lionel@mamane.lu>"> <span class="fn">Lionel Elie Mamane</span></a>
</span></b>
<pre>(In reply to Alex Thurgood from <a href="show_bug.cgi?id=126624#c10">comment #10</a>)
<span class="quote">> Ideally, the dialog itself would provide for separate fields for each part
> of the connection string and an extra field for supplementary parameters
> (where daisychaining of such connection string parameters is allowed), and
> would only provide those fields that would correspond to the selected DB
> type. In such a case, we could have example resource strings for each type
> of DB connection, but we are talking about at least of tens of different DB
> engines (certainly all of the main ones out there in use today). It seems to
> me that there is currently no way to do this simply (from a UI perspective)
> without causing frustration for the end user (...)</span >
It *is* possible, it is just more work. It means making a separate dialog for
each DBMS, like e.g. MySQL already has. It is completely possible, it just
needs work in LibreOffice UI and/or documentation for each DBMS.
There are two things in my mind:
* the one-line patch that we should do *now* to remove,
from the prompt that is used for _all_ DBMS
(that don't have a specific UI dialog in LibreOffice),
the misleading / wrong example.
* the "more work, but better for the user" solution,
which would be something like a combination of:
- lots of examples in documentation
- several DB-specific UI in the LibreOffice "new connection" dialog
But anyway, even if we do the "more work better" version, we _still_ need to
have a generic fallback for the unknown DBMS, so we _still_ need to do this
one-line patch.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>