Regarding the user testing comments "please add info on how to set up DSN", and never using the example DNS filename.
I expect the MySQL or MariaDB database server used as a template has good ODBC documentation. Unfortunately, the SQLite driver documentation does not document DNS for Windows and contains "TODO: improve documentation". The instructions should use the empty database file created previously. The following is suggested with an indicative first sentence to replace the whole (BG7302-CreatingADatabase) SQLite databases Initial preparation section beneath the note. Follow the instructions for your operating system. For example, in Windows: > 1. Run (Windows key + R) C:\Program > Files\LibreOffice\program\odbcconfig.exe the ODBC Data Source Administrator > 2. On the User DSN tab click the Add button to add a User Data Source Name > 3. Select the SQLite3 ODBC Driver (if it's not displayed it needs to be > installed) and click the Finish button > 4. When the SQLite ODBC DSN Configuration window opens enter the Data > Source Name: libretest-SQLite, Browse to the database test.db, and click > the OK button. The ODBC DNS can be reconfigured later if required. Regards > -- To unsubscribe e-mail to: [email protected] 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
