Thanks to the following community member kindly agreeing to me sending this email to the mailing list.
---------- Forwarded message --------- From: Maxim Mazurok <ma...@mazurok.com> Date: Sat, May 21, 2022 at 1:20 PM Subject: Re: Seeking User Test of LO Base install for SQLite in Windows To: flywire <flywi...@gmail.com> Hello! Took a quick look, and here are some thoughts: - In the "Initial preparations before connecting to an SQLite file" section, there's too much text about how to create an empty file - After using DB Wizard, I got "The connection to the data source "New Database" could not be established. - [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" error - The previous point is apparently because I skipped "Make sure that you follow the instructions given in the driver documentation to create an ODBC Data Source Name (DSN) for your database" because I was expecting that "create DSN" = "construct a connection URL something like mysql:host=localhost;dbname=example" - Now I'm looking at docs http://ch-werner.de/sqliteodbc/html/index.html and can't find instructions to set up DSN on Windows. In ODBC Data Source Admin I can't see SQLite driver, and the tool says on the Drivers tab to use the driver's setup program to add new. - Ok, figured it out. Apparently, I was using 32-bit Data Source Admin, and a 64-bit driver can only be managed by a 64-bit manager... - Yeah, after that everything worked - So, the major takeaway from this: if you listed 3 ways to create an empty file, please add info on how to set up DSN, their docs aren't good - Also, you say that the DB file is assumed to be "C:\my_databases\libretest.db" but then never really use this information down the road. Again, I was expecting that it'll be used to construct a DSN string, but it wasn't. It should be used in instruction how to use that ODBC driver tho. Hope it helps, cheers! On Tue, 17 May 2022 at 00:13, flywire <flywi...@gmail.com> wrote: > Thank you for offering to Test the LO Base install for SQLite in Windows. > Attached is a pdf draft of the current chapter nearing release with the > SQLite section commencing on p40. Please do not distribute it and destroy > any copies when you are finished so it does not become confused with the > final published version in > https://documentation.libreoffice.org/en/english-documentation/ > > The test should preferably be done on a computer with the latest > LibreOffice version installed ( > https://www.libreoffice.org/download/download/) and without a previous > ODBC driver or configured ODBC Data Source Name. > > Please provide a brief email report including: > > - description of tester and computer environment > - list of guide headings with any comments regarding the usability of > the documentation for intended users, particularly about clarity and any > errors or omissions in the process > - any information needed to support the documentation > - other comments > > Additional guidance can be given if needed where something is not clear. > If you agree, your report will be placed in the LibreOffice Documentation > site, currently on a public mailing list. > > Kind regards > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
