Specialized1
14th September 2009, 21:07
I faced with problem executing a stored procedure from my Firebird database.
I got an error:
"no permission for execute access to PROCEDURE MyProcedure Could not prepare statement"
I worked with several in my database and everything was fine. I have created the database in IBExpert tool and I did not fix Roles and users in database. So, I used a SYSDBA name and standard password.
I got and error during prepare QSQLQuery:
QSqlQuery query;
bool result = query.prepare("EXECUTE PROCEDURE MyProcedure (:a)");
QString err = query.lastError().text(); // "no permission for execute access to PROCEDURE...
query.bindValue(":a", 1);
query.exec();
...
I have tried to call procedure directly in IBExpert and FlameRobin tools and evething works fine, but using QT 4.5 - no.
Does anybody had such problem?
I have used:
- QT 4.5
- Firebird 2.1 (embedded server "fbclient.dll")
- WIN XP SP2
- connection string : "user id=SYSDBA;password=masterkey;server type=Embedded;auto_commit=True;auto_commit_level=4 096;connection lifetime=1; DataBase=EMPTY.FDB"
I got an error:
"no permission for execute access to PROCEDURE MyProcedure Could not prepare statement"
I worked with several in my database and everything was fine. I have created the database in IBExpert tool and I did not fix Roles and users in database. So, I used a SYSDBA name and standard password.
I got and error during prepare QSQLQuery:
QSqlQuery query;
bool result = query.prepare("EXECUTE PROCEDURE MyProcedure (:a)");
QString err = query.lastError().text(); // "no permission for execute access to PROCEDURE...
query.bindValue(":a", 1);
query.exec();
...
I have tried to call procedure directly in IBExpert and FlameRobin tools and evething works fine, but using QT 4.5 - no.
Does anybody had such problem?
I have used:
- QT 4.5
- Firebird 2.1 (embedded server "fbclient.dll")
- WIN XP SP2
- connection string : "user id=SYSDBA;password=masterkey;server type=Embedded;auto_commit=True;auto_commit_level=4 096;connection lifetime=1; DataBase=EMPTY.FDB"