Hi, We are trying to figure out how to use Qt Sqlite driver to use loadable extension mechanism. We have a shared library, which needs to be loaded after db is open. We are using Qt classes to make a connection to database, so our code looks like this:
QSqlDatabase db= QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("./testDb"); db.open(); .................. QSqlQuery query; query.exec("SELECT load_extension('myextensionlib.so')"); This fails with an error message 'not authorized'. I understand that I need to enable load extension mechanism by calling sqlite3_enable_load_extension(db, int 1) function, but since I use Qt I dont have db handle readily available. So, my question is whether there is another way to enable load extension mechanism? Is it possible to enable it by default somehow so that I wont have to call sqlite3_enable_load_extension function? I understand that I can build my extension into sqlite similar to fts1 and fts2, but I need to load it dynamically so this is not an option. Many thanks in advance for any suggestions. - Alex