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/118800.aspxSun, 15 Apr 2018 12:10:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118800Abdul Rahman0https://www.infopathdev.com:443/forums/thread/118800.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118800And, if there is any option for validating the submit? i need infopath to ask for the password while submitting the form,, is it possible? any reference you have? thanks againhttps://www.infopathdev.com:443/forums/thread/118799.aspxSun, 15 Apr 2018 12:09:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118799Abdul Rahman0https://www.infopathdev.com:443/forums/thread/118799.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118799You are most welcome. thanks a lot for the support..https://www.infopathdev.com:443/forums/thread/118674.aspxMon, 02 Apr 2018 14:54:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118674Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118674.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118674Oh! Thanks for posting back on this, I hadn't even thought about a missing primary key being the issue.https://www.infopathdev.com:443/forums/thread/118672.aspxSun, 01 Apr 2018 08:40:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118672Abdul Rahman0https://www.infopathdev.com:443/forums/thread/118672.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118672Hi Hilary, Waah, now I got submit option. There was no primary key I set for the table. I made number column as primary key, then tried modifying the data connection, now submit option is on my eyes..thanks for the support Let me go on, brb if any more issues, thanks again from UAEhttps://www.infopathdev.com:443/forums/thread/118671.aspxSun, 01 Apr 2018 08:06:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118671Abdul Rahman0https://www.infopathdev.com:443/forums/thread/118671.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118671Hi Hilary, My table contains 2 fields, Number (int) Name (nVARCHAR(50) any issues with this?https://www.infopathdev.com:443/forums/thread/118647.aspxThu, 29 Mar 2018 14:40:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118647Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118647.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118647Your database tables have none of the types that cause Submit to be disabled? Those are the only 2 things I know of that cause this. Form compatibility and data types.https://www.infopathdev.com:443/forums/thread/118644.aspxThu, 29 Mar 2018 11:35:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118644Abdul Rahman0https://www.infopathdev.com:443/forums/thread/118644.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118644hi, thanks again. Gone through the link you provided.. I already tried that, but no luck. I am using infopath 2013. i set the compatibilty, then tried to modify the connection. still the submit option is grayed out. Ooops, why microsoft made this complications.https://www.infopathdev.com:443/forums/thread/118631.aspxWed, 28 Mar 2018 16:18:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118631Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118631.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118631Submit may be disabled due to field types or if this is a browser form. Change the compatibility to Filler, and walk through the connection again. https://support.office.com/en-us/article/introduction-to-submitting-form-data-29b2e228-568d-4d97-bebb-8a92fde59c98#bm2 has info on data types.https://www.infopathdev.com:443/forums/thread/118629.aspxWed, 28 Mar 2018 13:25:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118629Abdul Rahman0https://www.infopathdev.com:443/forums/thread/118629.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118629Thank you Hilary, for the reply. But, my form is 2013 SQL Database form, connection established, and able retrieve data from the table. The Submit is grayed out while making connection and when I try submit, nothing happens. Please inform is there anything else i have to setup to make this Submit button work? I changed compatibility, trust, etc, still no luck. thanks again, from UAEhttps://www.infopathdev.com:443/forums/thread/118580.aspxWed, 21 Mar 2018 16:58:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118580Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118580.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118580In order to submit to SQL without code, you need to create the form from the Database template. To submit with code, not using a data connection, I'd think you'd need the form to be full trust - but if you have a receive data connection, you could probably leverage that & change the command to use a stored proc (for example) - passing in your form values in code.https://www.infopathdev.com:443/forums/thread/118578.aspxWed, 21 Mar 2018 06:59:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118578Abdul Rahman0https://www.infopathdev.com:443/forums/thread/118578.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=118578Hi, I am new to infopath, programmer for some other application. retrieving data from sql is working. Anybody give me an idea or link where i can learn to submit data to sql in infopath2013? I've trying this for 1 week in online, no help. Thanks,