InfoPath Dev

Thanks for the reply...From what I have been reading InfoPath has too many restrictions, maybe it's may lack of SQL skills...I don't know.  Anyway I have given up and now using a Ms Access DB which works fine. Thanks again and Merry Christmas

Thank you for all you responses, unfortunately though none of the suggestions work.  I should mention that I am using a SQL2005 DB with InfoPath 2003.   I have set my column in the DB to NVARCHAR(MAX) don't have a datatype of NVARCHAR(256) limiting the box doesn't do anything.  I get the following error when ...

Hi I'm new to all this, I have a 1 form that connects to a SQL 2005 DB.  I can retrieve and submit data.  I had to set all my Columns to nvarchar50 before the submit will work.  A limit of 50 is no good to me, I need at least 250 characters.  Does anyone have any suggestions please?   Many thanks