Friday, May 25, 2012

"Error when executing direct SQL – SqlStatementExecutePermission”


While accessing SQL statements within AX world I came across an error which was really time consuming for me to get rid of.

I created a method like this;

It got failed while executing statement and gave following error " Error when executing direct SQL – SqlStatementExecutePermission” on line resultSet = statement.executeQuery(sql);

SOLUTION:
You can solve this issue easily, if you use the method marked as server static and call this method from the display method. 

2 comments:

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...