SharePoint Integrationhttps://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)Re: Infopath/SharePoint/SQLhttps://www.infopathdev.com:443/forums/thread/16186.aspxThu, 06 Apr 2006 08:58:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16186AndersR0https://www.infopathdev.com:443/forums/thread/16186.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=16186Hi Luc and welcome to the forum :-)<br /><br />If you want to use SharePoint for some kind of web publishing, i cannot reccomend going directly to the SQL server!<br /><br />You risk compromising your portal and be sure that Microsoft wont help you if you did this :-O<br /><br />Instead you can make this possible using the soap web services that SPS has available for just this purpose:<br /><br />you could add data to custom lists in sharepoint or wss using lists.asmx web service (web method GetListItems) using CAML<br /><br />check either your SPS SDK or do a search for GetListItems in this forum to get a better picture of what is needed.<br /><br />hthInfopath/SharePoint/SQLhttps://www.infopathdev.com:443/forums/thread/15386.aspxThu, 06 Apr 2006 07:46:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:15386LWILPUTTE0https://www.infopathdev.com:443/forums/thread/15386.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=15386Hi everybody,<br />I'm trying to create a infopath forms available from the web via my sharepoint site.<br />In these forms I would like to use fields pointg to the SQL server of my Sharepoint server. That mean that I would like to create a specific table on the SQL Server and then, in a site, use forms able to add/modify records in that table.<br />Is that possible ?<br />Does anyone proceeded to this ?<br />Do I have to design the form directly on the server ?<br />Because when I'm designing a form on my local PC if I chose a SQL server as reference in the Datasource, I have to chose a SQL server recognized and available from my location at devel time... <br />And... <br />The SQL server used on my SharePoint server is not reachable at that moment...<br />Of course We can develop web parts in .NET technology but it would be rather quicker to use InfoPath if possible...<br /><br />Thanks in advance for your advises...<br /><br />Best regards.