InfoPath Dev

I have written a custom web service to receive data from SQL database. I want to use that web service in my info path form. I don't know how to deploy that web service. Can anyone guide me ?

Hi,

verify below links.

http://panvega.wordpress.com/2008/11/19/deploy-a-custom-webservice-into-the-sp-isapi-_vti_bin-filder/

http://www.dotnetheaven.com/Uploadfile/rajaduraip/SimplestwaytoCreateNDeployWebServices02122006232233PM/SimplestwaytoCreateNDeployWebServices.aspx

Thanks for your prompt reply. My web service is working fine in local system. But its not working in server. what i need to check in that? Is there any other way to deploy web service into Share point server?

Hello,

Can you check in your web.config file and the below statement is available,

<trust level="Full" originUrl="" />

What is the error you are getting? Can you give more details on your error message?

whether i need to enter anything in web.config file? I gave the data connection string in the web method itself.

While working in the local system its working file, but in the server i can able to call invoke method after that i got the following error

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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

   at Service.QueryDB(Int32 EMPLOYEE_NUMBER)

 

Hello,

Here is the link,

http://www.vbcity.com/forums/topic.asp?tid=105907&#RID380236.

You need to follow these steps,

1. Open solution explorer-->Click Project Properties--> Click Security tab-->Tick 'Enable Click One Security settings'.

2. Ensure you have selected 'This is a full trust application', or appropriate security settings.

3. Recompile and run.