ExecuteSQL Issue

Topics: Developer Forum, User Forum
Feb 17, 2014 at 2:07 PM
Hi all,

I'm using the ExecuteSQL part of the ASSP assemblies. I am receiving the below error from Excel when trying to fire off my action. I'm attempting a very basic SELECT FROM as my action so it's nothing overtly complex there.

Execution of the managed stored procedure ExecuteSql failed with the following error: Exception has been thrown by the target of an invocation. Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data...'

Any help would be appreciated. Thanks
Feb 17, 2014 at 6:37 PM
What permissions did you give the assembly when you installed it? see the Installation instructions for a screenshot of the options.

For ExecuteSQL I'm pretty sure it needs Unrestricted permissions in order to work.