https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17120.aspxWed, 18 Jan 2006 02:59:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17120Matt Faus0https://www.infopathdev.com:443/forums/thread/17120.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17120You should be able to edit your own posts. Start at your name and go to the right until you see an icon that looks like a pad of paper with a pencil over it.<br /><br />Anyway, this sounds like a connection issue - you might need to establish a VPN connection to connect to a remote database or at least configure the database to allow remote connections through the Internet.<br /><br />---------------<br />Matt Faus<br />InfoPath Dev Texas<br />https://www.infopathdev.com:443/forums/thread/17119.aspxWed, 04 Jan 2006 21:50:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17119ContractOne0https://www.infopathdev.com:443/forums/thread/17119.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17119Please revome the period on the pdf link to view (oops)<br /><br />If you ain't got the nuts, fold, or bluff like you do.https://www.infopathdev.com:443/forums/thread/16769.aspxWed, 04 Jan 2006 21:48:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16769ContractOne0https://www.infopathdev.com:443/forums/thread/16769.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16769I am using infopath and MS SPS for all common forms used in our company. I have designed the forms and need to get them tied to a database.<br />My final goal is to tie to a SQL database. <br />I can query & submit to a SQL database when I am within my office network. I can query a SPS list(not sure if I can submit to a SPS List) in and out of the office work space. I cannot figure out the webservice route.<br /><br />SQL:<br />I believe my issues with this is a rights issue when I am outside my office network. I get the following errors when I try to open a infopath form outside my office network www.bojik.com/SQL_Login.pdf.<br /><br />SPS List:<br />I have these working great in and out of the office network.<br /><br />Web Service:<br />I have done the Lab8 in Microsoft.com and still do not quite understand how a webservice gets the data from a database. (newbie to webservice)<br /><br />I want to use SQL as it will allow me to sync with my accounting database. The SPS List approach will work, but I have to update all of the lists manualy (ie. export a report to excel and copy to the linked SPS excel spreadsheet and sync. If I do a new list to replace the old list I get broken links in the infopath form). If webservice is also a option I need help on how to set one up and tie it to a sql database.<br /><br />Thanks in advance<br /><br /><br />If you ain't got the nuts, fold, or bluff like you do.