https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/116146.aspxWed, 26 Apr 2017 20:11:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116146CCBSMF0https://www.infopathdev.com:443/forums/thread/116146.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116146Well I will have to try this at another time. My boss just ordered me to remake the form for the environment. If I get some time I will see if I can do this and how to go about it.https://www.infopathdev.com:443/forums/thread/116145.aspxWed, 26 Apr 2017 18:53:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116145CCBSMF0https://www.infopathdev.com:443/forums/thread/116145.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116145Will do! I'll also post my success, if such, and how I went about it. Hopefully it may help someone else. :)https://www.infopathdev.com:443/forums/thread/116144.aspxWed, 26 Apr 2017 18:46:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116144Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/116144.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116144Holler if you get stuck, ok?https://www.infopathdev.com:443/forums/thread/116143.aspxWed, 26 Apr 2017 18:34:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116143CCBSMF0https://www.infopathdev.com:443/forums/thread/116143.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116143This was exactly what I was thinking. Thanks Hilary! :)https://www.infopathdev.com:443/forums/thread/116141.aspxWed, 26 Apr 2017 18:30:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116141Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/116141.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116141I think you could do this manually in the manifest.xsf file - you don't really have anything to lose. Save a copy of the form, and save as source files. Create a new form using the SQL DB you want to use for your main database connection, and then you'll be able to compare the manifest.xsf files to see what you have to change.https://www.infopathdev.com:443/forums/thread/116139.aspxWed, 26 Apr 2017 17:39:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116139CCBSMF0https://www.infopathdev.com:443/forums/thread/116139.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116139Hey Everyone. I have an older form that utilizes a UDCx for it's main connection. I was able to remove the secondary connections and re-add them as standard SQL connections. But the Main Connection I cannot remove and re-add. I was hoping that I can convert the UDC into a standard SQL connection by accessing the manifest and rewriting the XML to match that of a SQL connection. Is this option viable? or do I have to recreate the entire form? Any suggestions are welcome! :) Quick notes: IP 2010. Using old UDCx connections to SharePoint but want to use standard SQL db connections. Very comfortable with XML editing and compositions.