MS SQL Field Limits and Hosting Options? - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

MS SQL Field Limits and Hosting Options?

Last post 08-29-2011 05:38 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-24-2011 10:26 AM

    • nc1787
    • Not Ranked
    • Joined on 07-29-2011
    • Posts 4

    MS SQL Field Limits and Hosting Options?

    I 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?
  • 08-29-2011 05:38 PM In reply to

    Re: MS SQL Field Limits and Hosting Options?

    Hi NC1787,

    Sorry for the delay in responding to your post.

    Qdabra offers InfoPath-SQL hosting - see FormsBoard dot com for details.

    Qdabra also offers a Web service 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's easy to get it up and running, but you'll want to recreate your form using an XML schema and not a schema derived from the Access Database (which will intrinsically limit you).


    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.