LO Base does not support "Relationship" for SQlite Database both as external or embeded mode. Someone please help

[WaterDrop]

LO Base does not support “Relationship” for SQlite Database both as external or embedded mode. I am using “jdbcDriverOOo.oxt” and “SQLiteOOo.oxt” extension for Embedded mode. And unixODBC driver for external mode. Use chinook.db (SQLite Sample Database And Its Diagram (in PDF format)) for testing as external SQlite database. Someone please help

[Villeroy]

"The database does not support relations" connecting to SQLite database via ODBC

I am using Base to connect to a SQLite database via ODBC. My intention was to use Base as a front end to graphically view relations and create and use forms. I am using the Chinook sample database for testing. When opening the Relations window, I get the message “The database does not support relations.”. Is what I am attempting feasible? If so, what am I doing wrong? I’m very new to databases. Any help appreciated. Version: 24.8.5.2 (X86_64) / LibreOffice Community Build ID: fddf2685c70b4…

[WaterDrop]

Facing the same problem as you have posted but no solution yet.

[Villeroy]

SQLite does not support relations. Use it as is, or use another database engine.