Problem with Database Connection - SOLVED

[Miguel_Castilla]

Hi
I’m having issues with connecting to a simple database. It’s my first time with SQL and ODBC.
Following SumantKhalate’s steps, I have managed to get his database working, even though I am using linux. However, when I follow the steps with my own database I can’t see any symbol:

However, in my SQL database, i can see the library of my symbols:

I think my kicad_dbl is fine because otherwise it wouldn’t appear in kicad, but I’ll show it to you just in case there’s something wrong

{
    "meta": {
        "version": 0
    },
    "name": "My Database Library",
    "description": "A database of components",
    "source": {
        "type": "odbc",
        "dsn": "",
        "username": "",
        "password": "",
        "timeout_seconds": 2,
        "connection_string": "DSN=Prueba;"
    },
    "libraries": [
        {
            "name": "Capacitors",
            "table": "Capacitors",
            "key": "Part ID",
            "symbols": "Symbols",
            "footprints": "Footprints",
            "fields": [
                {
                    "column": "MPN",
                    "name": "MPN",
                    "visible_on_add": false,
                    "visible_in_chooser": true,
                    "show_name": true
                },
                {
                    "column": "Value",
                    "name": "Value",
                    "visible_on_add": true,
                    "visible_in_chooser": true
                }
            ],
            "properties": {
                "description": "Description"
            }
        },
        {
            "name": "Resistors",
            "table": "Resistors",
            "key": "Part ID",
            "symbols": "Symbols",
            "footprints": "Footprints",
            "fields": [
                {
                    "column": "MPN",
                    "name": "MPN",
                    "visible_on_add": false,
                    "visible_in_chooser": true
                },
                {
                    "column": "Value",
                    "name": "Value",
                    "visible_on_add": true,
                    "visible_in_chooser": true
                }
            ],
            "properties": {
                "description": "Description"
            }
        }
    ]
}

Finally, I show you my odbc.ini and how I have connection with my SQL database:

[Prueba]
Description=My SqLite sample database
Driver=SQLite3
Database=/home/xxx/Descargas/Otros/sqlite/Prueba.kicad_dbl

Thanks and sorry for my English,
Miguel

[JPR75]

Hi,

Is your symbols and footprints Global Path set correctly?
Can you see the symbols in the symbol editor and the footprints in footprint editor?

[Miguel_Castilla]

@JPR75
Thanks for quick reply. I think it’s correct, because the SumantKhalate’s database use the same symbols for capacitors and resistors than me:

Also, I can see the symbols of his database:

The only difference is that I don’t use footprint in SQL database because I only want to see symbols on the schematic.

[Miguel_Castilla]

I don’t know the reason but I’ve tried the same steps since several times and I got it to work. Thanks for the help @JPR75