If using the default configuration (stand alone embedded Firebird configuration), when you go to run QBI, you may receive an error, that when you click on the Details button displays the following message:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> FirebirdSql.Data.Firebird.FbException: no permission for read/select access to TABLE AINTEGRATIONLOG
at FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery()
at GZTW.Data.GZTWDatabase.DoExecuteNonQuery(DBCommandWrapper command)
at GZTW.Data.GZTWDatabase.ExecuteNonQuery(DBCommandWrapper command)
at GZTW.AyaNova.BLL.IntegrationLog.DataPortal_Update()
— End of inner exception stack trace —
Solution:
click Quit on the error message
Edit the AyaNovaQBI.exe.config file so that the user and password are not included in the configuration string
For example: your AyaNovaQBI.exe.config file may have the following line as you are using the default embedded configuration:
<add key=“DataBaseConnectionString” value=“ServerType=1;DataBase=AYANOVA.FDB;User=AYANOVA;Password=AYANOVA;Dialect=3;” />
Instead, edit the line so that the user and password are removed:
<add key=“DataBaseConnectionString” value=“ServerType=1;DataBase=AYANOVA.FDB;Dialect=3;” />
.
.
NOTE: As of August 2006 installations of AyaNova will default to not include the User=AYANOVA;Password=AYANOVA to make it easier to follow the configuration instructions