Bug 148186 - Potentially confusing text label on Base Database Wizard when connecting to a Firebird file
Summary: Potentially confusing text label on Base Database Wizard when connecting to a...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Firebird-Default Database-Connectivity
  Show dependency treegraph
 
Reported: 2022-03-25 17:19 UTC by Steve Fanning
Modified: 2023-04-30 08:07 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Connection to a Firebird server database by internal server and JDBC simultaneously (88.27 KB, image/png)
2022-03-26 23:27 UTC, jcsanz
Details
Connection to a registered Firebird server database (27.87 KB, image/png)
2022-03-26 23:27 UTC, jcsanz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Fanning 2022-03-25 17:19:28 UTC
Description:
When connecting to a Firebird file via the Database Wizard, there is a text field for entry of the file's location. The legend adjacent to this field is "Datasource URL (e.g. host=$host=$host:$port dbname=$database)". The text of this legend may have been copied/pasted from a similar field for creating a JDBC connection but is very likely to confuse users in this context. Consider replacing this text when connecting to a Firebird file with something simpler and more relevant, such as "File location".

Steps to Reproduce:
1. In any LO component, select File > New > Database on Menu bar.
2. At Step 1 of the Database Wizard, click the "Connect to an existing database" option and select the "Firebird File" entry in the adjacent drop-down menu.
3. Click the "Next" button.
4. At Step 2 of the Database Wizard, notice the legend positioned above the text field. It reads "Datasource URL (e.g. host=$host=$host:$port dbname=$database)".

Actual Results:
Not applicable

Expected Results:
Not applicable


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 6; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_GB); UI: en-US
Calc: CL
Comment 1 Robert Großkopf 2022-03-25 18:31:06 UTC
(In reply to Steve Fanning from comment #0)
> 4. At Step 2 of the Database Wizard, notice the legend positioned above the
> text field. It reads "Datasource URL (e.g. host=$host=$host:$port
> dbname=$database)".

This has been changed from LO 7.2.5 to LO 7.3.2. Now there appears:
"Enter the DBMS/driver-specific connection string here".

This should be better something like:
"Enter or choose the URL to the Firebird file here".

Used version here:
Version: 7.3.2.2 / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
Comment 2 jcsanz 2022-03-26 18:50:40 UTC
> This should be better something like:
> "Enter or choose the URL to the Firebird file here".

 Since it is posible connect to a database server also it would be better "Enter or choose the URL to the Firebird database here"
Comment 3 Robert Großkopf 2022-03-26 19:42:36 UTC
(In reply to jcsanz from comment #2)
> > This should be better something like:
> > "Enter or choose the URL to the Firebird file here".
> 
>  Since it is posible connect to a database server also it would be better
> "Enter or choose the URL to the Firebird database here"

Is it really possible to connect to the server with the internal driver? It is possible to connect to a file, if the file is in a path the user could read and write to. But a server? I only know the possibility to connect trough JDBC and ODBC.
Comment 4 jcsanz 2022-03-26 23:27:04 UTC
Created attachment 179133 [details]
Connection to a Firebird server database by internal server and JDBC simultaneously

Connection established simultaneously by mean of internal driver an JDBC driver
Comment 5 jcsanz 2022-03-26 23:27:49 UTC
Created attachment 179134 [details]
Connection to a registered Firebird server database
Comment 6 jcsanz 2022-03-26 23:28:24 UTC
(In reply to Robert Großkopf from comment #3)
> (In reply to jcsanz from comment #2)
> > > This should be better something like:
> > > "Enter or choose the URL to the Firebird file here".
> > 
> >  Since it is posible connect to a database server also it would be better
> > "Enter or choose the URL to the Firebird database here"
> 
> Is it really possible to connect to the server with the internal driver? It
> is possible to connect to a file, if the file is in a path the user could
> read and write to. But a server? I only know the possibility to connect
> trough JDBC and ODBC.

I think it is. You can see it in the attached images
Comment 7 Heiko Tietze 2022-03-30 07:11:22 UTC
(In reply to Robert Großkopf from comment #1)
> "Enter or choose the URL to the Firebird file here".

The previous label "Enter the DBMS/driver-specific connection string here" is generic and works for other types as well (JDBC and PostgreSQL at least). Now it's easy to understand, and the original issue has been solved => WFM or DUP of bug 126624