Hello, I am trying to setup database library.
For start I want to use SQLite 3 embedded in each project.
I have *.kicad_dbl file and *.sqlite3 file in the same directory.
I was able to use DSN to connect to my database and I was able to use following connection string:
"connection_string": "DRIVER=SQLite3 ODBC Driver;Database=C:\\Users\\me\\Documents\\miscellaneous\\project\\kicad-files\\kicad-lib\\parts_database.sqlite3;"
Would it be possible to use relative path?
This did not work:
"connection_string": "DRIVER=SQLite3 ODBC Driver;Database=.\\parts_database.sqlite3;"
Errors loading symbols:
Error loading symbol library database_lib.
Could not load database library: could not connect to database (C:\jenkins\workspace\build-windows-kicad-msvc-7.0-stable.build\kicad\thirdparty\nanodbc\nanodbc\nanodbc.cpp:1044: 0100: connect failed [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed [Microsoft][ODBC Driver Manager] The driver doesn’t support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). )
This also fails with the same error:
"connection_string": "DRIVER=SQLite3 ODBC Driver;Database=parts_database.sqlite3;"
I am running KiCad 7.0.7