SQL Database Integrationhttps://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)Re: MS SQL Field Limits and Hosting Options?https://www.infopathdev.com:443/forums/thread/69799.aspxTue, 30 Aug 2011 00:38:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69799Patrick Halstead0https://www.infopathdev.com:443/forums/thread/69799.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=69799<p>Hi NC1787,</p> <p>Sorry for the delay in responding to your post.</p> <p>Qdabra offers InfoPath-SQL hosting - see FormsBoard dot com for details. </p> <p>Qdabra also offers a <a title="DBXL" href="http://www.qdabra.com/en/products/DBXL.aspx">Web service</a> that will store your XML as a blob in SQL (in addition to mapping it out to your database for reporting and downstream, line-of-business consumers). Since it stores it as an XML blob, it supports 100% fidelity for rich XML content - large fields, images, rich text, etc. The trial is free and the cost is low (and based on server not client access). It&#39;s easy to get it up and running, but you&#39;ll want to recreate your form using an XML schema and not a schema derived from the Access Database (which will intrinsically limit you).</p> <p>&nbsp;</p>MS SQL Field Limits and Hosting Options?https://www.infopathdev.com:443/forums/thread/69604.aspxWed, 24 Aug 2011 17:26:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69604nc17870https://www.infopathdev.com:443/forums/thread/69604.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=69604I have a form used to collect info in reguards to Incident Reports. It is for a security company and everytime we respond to an incident there is a report to follow. We had previously been using a paper system but have recently moved to using InfoPath connected to an Access Database. Currently Access limits me to 255 characters in a field and InfoPath will not accept the Memo field option of Access. I need fields that will allow way more than 255 characters. Will a MS SQL database allow text fields to be more than 255? If so how many characters? If not...what are some other options? Also, if MS SQL is the way I need to go....what are my options as far as hosting? Are there any recommended hosting companies? What will I need to look for in a hositng company to suit my needs with InfoPath?