KiCad database library error?

Schematic Library Symbols
1

Dear all,

I’m trying to get the database library function operational but I get this error when I want to add a component to the schematic.

Errors loading symbols:
Error loading symbol library cspect_lib.
Could not load database library: could not connect to database (C:\jenkins\workspace\build-windows-kicad-msvc-8.0-stable\.build\kicad\thirdparty\nanodbc\nanodbc\nanodbc.cpp:1044: IM00: [Microsoft][ODBC Driver Manager] The data source name was not found and no default driver was specified )

My JSON file:

{
    "meta": {
        "version": 0
    },
    "name": "CSPECT component database",
    "description": "A database of electronic components for KiCAD",
    "source": {
        "type": "odbc",
        "dsn": "",
        "username": "",
        "password": "",
        "timeout_seconds": 2,
        "connection_string": "DRIVER=SQLite3 ODBC Driver;Database=Z:\\CSPECT\\0.General\\0.6 R&D\\KICAD\\parts library.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;"
    },
    "libraries": [
        {
            "name": "Connectors",
            "table": "Connectors",
            "key": "id",
            "symbols": "Symbol",
            "footprints": "Footprint",
            "fields": [],
            "properties": {
                "description": "DESCRIPTION"
            }
        },
        {
            "name": "Microcontrollers",
            "table": "Microcontrollers",
            "key": "id",
            "symbols": "Symbol",
            "footprints": "Footprint",
            "fields": [],
            "properties": {
                "description": "DESCRIPTION"
            }
        },
        {
            "name": "Transistors/Mosfet",
            "table": "Transistors/Mosfet",
            "key": "id",
            "symbols": "Symbol",
            "footprints": "Footprint",
            "fields": [],
            "properties": {
                "description": "DESCRIPTION"
            }
        },
        {
            "name": "DIODE",
            "table": "DIODE",
            "key": "id",
            "symbols": "Symbol",
            "footprints": "Footprint",
            "fields": [],
            "properties": {
                "description": "DESCRIPTION"
            }
        },
        {
            "name": "Resistors",
            "table": "Resistors",
            "key": "id",
            "symbols": "Symbol",
            "footprints": "Footprint",
            "fields": [],
            "properties": {
                "description": "DESCRIPTION"
            }
        }
    ]
}
2

If you open the Windows ODBC tool (search it in the start menu) and go to the Drivers tab, what is listed?

3

I guess you mean this window @craftyjon ?

image
image742×526 118 KB

4

Yes that’s the one.

Do you have the SQLite 3 driver installed? I don’t see it on that list, but it also looks like the list can be scrolled.

You can get it from SQLite ODBC Driver - direct download sqliteodbc_w64.exe

You may also have to refer to the driver as {SQLite3 ODBC Driver} (with the curly braces) in the connection string, looking at the driver documentation. I don’t currently have access to a Windows machine to test this, though.