Hi, I am unable to connect to MS SQL server database in form load code in C#. I am using infopath 2010. It gives permission exception(Detailed exception given below).
Please help me out in geting rid of this issue.
Below is code i am using in my Form load:
using (SqlConnection conn = new SqlConnection("Data Source=systemName\\servername;Initial Catalog=SharePoint_DB;User ID=admin;Password=Pass01*;Integrated Security=true;"))
{
conn.Open();
emailAlias.SetValue("xyz");
conn.Close();
}
Exception at connection Open() statement :
[System.Security.SecurityException] = {"Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."}
thanks beforehand
raj