https://www.infopathdev.com:443/forums/48.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17600.aspxWed, 19 Jan 2005 02:44:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17600GaryR0https://www.infopathdev.com:443/forums/thread/17600.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=17600Hi again Patrick<br /><br />I successfully completed Lab 9 of the InfoPath Training which guides through creating a basic Web Service and connecting to InfoPath. <br /><br />However...<br />The example users the Customer table only. When I tried to do it again using two tables I get an error in the Data Adapter Config Wizard after creating the SQL query which says something to the effect - Generated INSERT, UPDATE, DELETE can't be done because the query has multiple tables.<br /><br />Secondly, to my limited knowledge instead of using the "Use SQL Statements" shown in the Lab would it be better to use the "Create new stored procedures" option.<br /><br />Any help would be appreciated.<br /><br />Thanks<br /><br /><br />Gary Robertshttps://www.infopathdev.com:443/forums/thread/17599.aspxTue, 18 Jan 2005 01:23:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17599GaryR0https://www.infopathdev.com:443/forums/thread/17599.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=17599Hi Patrick<br /><br />Thanks, that would be most interesting. I have done more research on the topic but I keep seeing different methodologies. I am looking for best practice to access Retrieve and Update records from a SQL database via a Web Service, and obviously use InfoPath as the frontend.<br /><br />Thanks<br /><br />Gary<br /><br />Gary Robertshttps://www.infopathdev.com:443/forums/thread/17598.aspxFri, 14 Jan 2005 00:38:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17598Patrick Halstead0https://www.infopathdev.com:443/forums/thread/17598.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=17598Gary, I'm going to try to expose a Web service on our site and give you some sample code for it.https://www.infopathdev.com:443/forums/thread/17597.aspxFri, 14 Jan 2005 00:36:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17597Patrick Halstead0https://www.infopathdev.com:443/forums/thread/17597.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=17597Hi Gary,<br />Sorry to hear about your problem. I need to investigate this. Check back in a couple days.<br />Patrickhttps://www.infopathdev.com:443/forums/thread/17454.aspxWed, 12 Jan 2005 02:07:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17454GaryR0https://www.infopathdev.com:443/forums/thread/17454.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=48&PostID=17454Hi<br /><br />I am quite new to InfoPath and all the related technologies. I have your excellent book. <br /><br />I was very happy to create my first web service in vb.net which accesses a SQL database. It works with ASP.Net and Windows form. When I tried to use it with InfoPath I got an error talking about unsupported Web Services. <br /><br />As I am just learning, this is not good news. I have seen a workaround on pg 226 of your book. It uses .Net Web References. I tried to follow it with my own Web Service but don't understand how to apply it. One of the problems is the OakleafWS is not working and I can't see what you are trying to do.<br /><br />How can I use this solution or alternatively how do I create a simple Web Service that InfoPath will support.<br /><br />Many thanks<br /><br />Gary<br /><br />Gary Roberts