Re: Failed to connet SqlClient

Greg Collins — Fri, 11 Aug 2006 16:14:32 GMT

Great! Glad to have been able to help!

Re: Failed to connet SqlClient

angie — Fri, 11 Aug 2006 09:40:28 GMT

Thankx Greg Collins. After set to Full Trust Form and the error no occur anymore.

Re: Failed to connet SqlClient

Greg Collins — Wed, 09 Aug 2006 17:49:23 GMT

Your error indicates that this is a security issue.

1. Check your permissions.
2. Try creating a full trust form.

Failed to connet SqlClient

angie — Wed, 09 Aug 2006 09:31:43 GMT

I'm using InfoPath 2007. I try to retrieve the records from SQL server and update the form's field but system prompt the following error when execute the code "MyConnection.Open();"

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.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at StaffAbsenceRequestForm.FormCode.CTRL39_5_Clicked(Object sender, ClickedEventArgs e)
at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

Please advice and suggest the solution.

Thank you.

Regards,
-angie-

Data Connections

Re: Failed to connet SqlClient

Re: Failed to connet SqlClient

Re: Failed to connet SqlClient

Failed to connet SqlClient