No available SQL option

[SteveBredebach]

I downloaded and installed the 2.6.0 Version of xca, we use a SQL database for the certificates. I added the MinGW compiled .dll files and added them in the application directory of xca. But if i try to open a network database, there is still only the ODBC option visible. Did i miss something? I already tried an older version of the driver, but xca crashes instantly with them... So i know it must be loading the SQL drivers.

[chris2511]

There are 2 required drivers

1. qsqlmysql.dll placed in the sqldrivers subdirectory, written by QT, connecting the QT-SQL interface to the MySQL C-Functions
2. libmysql.dll placed in the application directory of xca (or any other standard DLL location), written by Oracle/mysql, implementing the MySQL C-Functions to talk to the mysql server via network or socket

Please see https://github.com/thecodemonkey86/qt_mysql_driver?tab=readme-ov-file#deployment

Once the qsqlmysql.dll is available in the sqldrivers directory, it should be selectable in the XCA GUI.
If the libmysql.dll is not available, XCA will show the error "Driver not loaded"

[SteveBredebach]

Thanks for your answer!

This is my sqldrivers-folder with the qsqlmysql.dll

This is my application folder.

As you can see, both dlls are available, but neither i am getting the "Driver not loaded" error or the SQL option in the dropdown.