InfoPath Dev

I opened all the source files for a form one by one and and replaced all references of "http://test/sql/endpointname?wsdl" to "http://prod/sql/endpointname?wsdl"  with notepad find-and-replace.  The manifest file also had a reference to my test sharepoint form library so I changed that to refer to the form library on ...

I am using a SQL endpoint web service to connect from InfoPath several forms to a SQL database.  I developed all my forms in a test environment first and all are working well.  Now I want to move those forms into a production environment but I need to change the connection path to the production SQL endpoint so the forms will use the ...

My issue was not the comment field at all.  It was the fact that there were columns with NULL values in the SQL row I was testing on.  InfoPath doesn't like dealing with NULL columns in the form.  I tested the comment field on a record that had all other columns set to some value other than NULL and the update worked fine.

I have created a form that submits to a SQL endpoint web service and all went well until I added a comment column to my SQL table defined as Stncomment nvarchar(255).  After adding this column I can no longer submit and save a record back to SQL through the web service.  I have tried resetting the data connection in InfoPath (2007) and ...