When moving from linux to win I recall the oddity of the required ODBC extra step and how the connection line changes to match the odbc name. This is on win 10 – connection line points to odbc nickname which you define in the odbc tool, and the “configure” button is where you point it to the actual database file:
My little database adventure documented here (linux at the beginning and win at the end):
https://forum.kicad.info/t/a-database-case-study/39631
And a custom BOM script for my db:
https://forum.kicad.info/t/create-bom-referencing-master-parts-list/56043/15