QT6 Static Build error undefined reference to `SQLGetInfoW'

fadu

after finish building static and everything done
when i add qmysql codes and try to run the program
i see all this errors
alt text
this is compile static paramter

cmake -DCMAKE_BUILD_TYPE=Debug -DBUILD_SHARED_LIBS=OFF -DQT_BUILD_EXAMPLES=OFF -DINPUT_static_runtime=ON -DFEATURE_ltcg=OFF -DBUILD_qtwebengine=OFF -DOPENSSL_ROOT_DIR="C:\OpenSSL\openssl-1.1.1i\static\x64\debug" -DOPENSSL_USE_STATIC_LIBS=TRUE -DOPENSSL_MSVC_STATIC_RT=TRUE -DINPUT_sql_mysql=ON -DMySQL_INCLUDE_DIRS="C:\2\include" -DMySQL_LIBRARIES="C:\2\lib\mysqlclient.lib" -DCMAKE_INSTALL_PREFIX="C:\Qt\static" -G Ninja C:\Qt\6.1.2\Src

also i add sql to my .pro file ```

QT       += core gui sql

ChrisW67

"When I add mysql codes", and a list of ODBC-related linker errors do not go together.

I guess your static libraries have the Qt ODBC driver included and your application link options do not include the relevant Windows ODBC driver link libraries (odbc32.lib I think).

fadu

@ChrisW67
i'm using qmysql only

fadu

QSqlDatabase db ;
db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("hhostip");
db.setUserName("user");
db.setPassword("pass");
db.setDatabaseName("dbname");
if(db.open())
{
ui->textEdit->setText("Ok");
//db.close();
}
else {
ui->textEdit->setText("No");
db.close();
}

SGaist

Hi,

From the looks of it, you are not linking to the MySQL plugin exclusively.

See here for more information about static plugins.

fadu

@SGaist can i edit configure (then rebuild it ) and link qmysql exclusivly becuase i didn't need any other sql type like odbc or sqlite

SGaist

Configure what ?

fadu

@SGaist
i mean the configure line of static build

cmake -DCMAKE_BUILD_TYPE=Debug -DBUILD_SHARED_LIBS=OFF -DQT_BUILD_EXAMPLES=OFF -DINPUT_static_runtime=ON -DFEATURE_ltcg=OFF -DBUILD_qtwebengine=OFF -DOPENSSL_ROOT_DIR="C:\OpenSSL\openssl-1.1.1i\static\x64\debug" -DOPENSSL_USE_STATIC_LIBS=TRUE -DOPENSSL_MSVC_STATIC_RT=TRUE -DINPUT_sql_mysql=ON -DMySQL_INCLUDE_DIRS="C:\2\include" -DMySQL_LIBRARIES="C:\2\lib\mysqlclient.lib" -DCMAKE_INSTALL_PREFIX="C:\Qt\static" -G Ninja C:\Qt\6.1.2\Src

SGaist

I currently don't know if you can easily change that using cmake.

fadu

i tried this code to skip odbc sql

cmake -DCMAKE_BUILD_TYPE=Debug -DBUILD_SHARED_LIBS=OFF -DQT_BUILD_EXAMPLES=OFF -DINPUT_static_runtime=ON -DFEATURE_ltcg=OFF -DBUILD_qtwebengine=OFF -DINPUT_sql_odbc=OFF -DINPUT_sql_mysql=ON -DMySQL_INCLUDE_DIRS="C:\2\include" -DMySQL_LIBRARIES="C:\2\lib\mysqlclient.lib" -DMySQL_USE_STATIC_LIBS=TRUE -DCMAKE_INSTALL_PREFIX="C:\Qt\static" -G Ninja C:\Qt\6.1.2\Src

but doesn't work

SGaist

And why not just modify the list of linked plugins like shown in the documentation I linked ?