AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Error "no permission for read/select access... Expand / Collapse
Author
Message
Posted 4/10/2006 2:18:20 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 12:27:31 PM
Posts: 1,760, Visits: 4,098
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

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #1162
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 4:14am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.078. 9 queries. Compression Disabled.