sql query in crm plugin

(0) Share

Report

Posted on by Community Member

i write this query in a crm plugin but i get this error

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed

SqlConnection myConnection = new SqlConnection("Data Source=........;Initial Catalog=......;Persist Security Info=True;User ID=sa;Password=.......;");
SqlCommand myCommand = new SqlCommand("[Depart]FROM [mbm_MSCRM].[dbo].[vwPayrollEmployees] WHERE [mbmhr_EmployeeNbr] =@EmpNbr", myConnection);
myCommand.Parameters.Add("@EmpNbr", empnbr);

myCommand.Connection = myConnection;
myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader();

while (myReader.Read())
{
vdep = myReader["[Depart]"].ToString();

}
myConnection.Close();

i create this view (vwPayrollEmployees) in crm database

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Daniel Wikell 2,360 on at

Like (1)

Report

Is your plugin running in isolated (sandboxed) mode? If so, you are restricted in what kind of operations you are allowed. If you are running an onpremise version of CRM and want to use requests like this you need to set isolation mode to "none" for the plugin assembly.

Was this reply helpful? Yes No
Hosk on at

Like (0)

Report

can you access the SQL database from the CRM server where the plugins are deployed. Try logging onto the server and access that SQL database with the credentials you are using in the plugin

is the user name and password correct.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

the user name and pass correct

Was this reply helpful? Yes No