This project has moved and is read-only. For the latest updates, please go here.

ExecuteSQL Issue

Topics: Developer Forum, User Forum
Feb 17, 2014 at 3: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 7: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.