I have found the problem! The problem is during connection to the database.
I wrote:
database.setDatabaseName("D:\Test\d1.fdb");
database.setConnectOptions(user id=SYSDBA;password=masterkey;server type=Embedded;auto_commit=True;auto_commit_level=4096;connection lifetime=1; DataBase="D:\Test\d1.fdb");
QSqlDatabase database;
database.setDatabaseName("D:\Test\d1.fdb");
database.setConnectOptions(user id=SYSDBA;password=masterkey;server type=Embedded;auto_commit=True;auto_commit_level=4096;connection lifetime=1; DataBase="D:\Test\d1.fdb");
To copy to clipboard, switch view to plain text mode
But should be:
database.setDatabaseName("D:\Test\d1.fdb");
database.setUserName("SYSDBA");
database.setPassword("masterkey");
database.setConnectOptions(server type=Embedded;auto_commit=True;auto_commit_level=4096;connection lifetime=1; DataBase="D:\Test\d1.fdb");
QSqlDatabase database;
database.setDatabaseName("D:\Test\d1.fdb");
database.setUserName("SYSDBA");
database.setPassword("masterkey");
database.setConnectOptions(server type=Embedded;auto_commit=True;auto_commit_level=4096;connection lifetime=1; DataBase="D:\Test\d1.fdb");
To copy to clipboard, switch view to plain text mode
So, we should set User name and Password using methods "setUserName", "setPassword". That is why I did not have permissions to execute procedures.
Bookmarks