Hello everybody. I am new at KiCAD and also new at Linux. Got some problems with connection KiCAD libraries and Sqlite database. After configuring JSON file and trying to add it into symbol libraries of KiCAD i got messege:
“Symbol library ‘Data_base’ failed to load.
Could not load database library: could not connect to database (/usr/src/debug/kicad/kicad/thirdparty/nanodbc/nanodbc/nanodbc.cpp:1044: 0100: [unixODBC][Driver Manager]Can’t open lib 'SQLite3 ’ : file not found )”.
I downloaded `ODBCDriver.sqliteodbc from flatpack. but I dont know how to refer to it.
JSON file:
{
“meta”: {
“version”: 0
},
“name”: “Database Library”,
“description”: “A database of components”,
“source”: {
“type”: “odbc”,
“dsn”: “”,
“username”: “”,
“password”: “”,
“timeout_seconds”: 2,
“connection_string”: “Driver=SQLite3 ; Database=/home/dm/.local/share/kicad/8.0/symbols/Kicad_DBlib.sqlite3”
},
“libraries”: [
{
“name”: “Resistors”,
“table”: “Resistors”,
“key”: “key”,
“symbols”: “Symbols”,
“footprints”: “Footprints”,
"fields": [
{
"column": "key",
"name": "PartID",
"visible_on_add": false,
"visible_in_chooser": true,
"show_name": true
},
{
"column": "Part Number",
"name": "Part Number",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
},
{
"column": "Manufacturer",
"name": "Manufacturer",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
},
{
"column": "Size",
"name": "Size",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
},
{
"column": "Power",
"name": "Power",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
},
{
"column": "Value",
"name": "Value",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
},
{
"column": "Range",
"name": "Range",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
},
{
"column": "Datasheet",
"name": "Datasheet",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
},
{
"column": "Store",
"name": "Store",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
},
{
"column": "Quantity",
"name": "Quantity",
"visible_on_add": false,
"visible_in_chooser": false,
"show_name": false,
"inherit_properties": false
}
],
"properties": {
"description": "Description",
"footprint_filters": "Footprint Filters",
"keywords": "Keywords",
"exclude_from_bom": "No BOM",
"exclude_from_board": "Schematic Only"
}
}
]
}
