Bug 138265 - incorrect message for undefined ODBC DSN
Summary: incorrect message for undefined ODBC DSN
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha1+
Hardware: All Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-16 18:57 UTC by Terrence Enger
Modified: 2023-07-17 17:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
broken database file (1.74 KB, application/vnd.oasis.opendocument.database)
2020-11-16 18:57 UTC, Terrence Enger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Terrence Enger 2020-11-16 18:57:30 UTC
Created attachment 167337 [details]
broken database file

STR

(1) Optionally download attached example_odbc.odb and skip to step 8.

(2) Run soffice with command-line parameter --base.  Program presents
    database wizard step "Select database".

(3) Click radio button "Connect to an existing database" and in the
    dropdown list click ODBC.  Click button <Next>.  Program presents
    database wizard step "Set up ODBC connection".

(4) In "Name of the ODBC data source on your system" type
    "nonexistent".  Click button <Next>.  Program presents database
    wizard step "Set up user authentication".

(5) Click <Next>.

(6) Click radio button "No, do not register ..."; uncheck "Open the
    database ..."; click button <Finish>.  Program presents dialog
    "Save as".

(7) Save the database as example_odbc.  Program closes.

(8) Open example_odbc.odb.  Program displays main database
    window.

(9) In pane Database, click <Tables>.

    Observed:  Program displays msgbox

        The connection to the data source "example_odbc" could not be
        establised.

        [unixODBC][Driver Manager]Data source name not found, and no
        default driver specified
        /home/terry/lo_hacking/git/libo6/connectivity/source/drivers/odbc/OTools.cxx:357

    Expected : The message should name "nonexistent" as the data
               source.

I observed this in a local build of commit 38b1497d (2020-11-04) built
and running on debian-buster.
Comment 1 Robert Großkopf 2020-11-17 17:27:00 UTC
You are right. The messages, which appears, shows the name of the database file, not the name of the database source.

Confirming with LO 7.0.3.1, but it would be a very old bug. 

Note: Internal databases should show the name of the database file, because the database in the file is almost "hsqldb" or "firebird". External databases should show the name of the database.
Comment 2 QA Administrators 2022-11-18 03:36:09 UTC Comment hidden (obsolete)
Comment 3 Terrence Enger 2023-07-17 17:51:12 UTC
I still see the problem in my dbgutil of LibreOffice
        Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID:
        bfa25258d21430560584e3265cdd4629ee47a1b8 CPU threads: 8; OS:
        Linux 6.3; UI render: default; VCL: gtk3 Locale: en-CA
        (en_CA.UTF-8); UI: en-US Calc: threaded
built and running of debian-sid.