InfoPath form connected to DB

[purple]

I have an InfoPath form that submits data to DB.

There is a limitation of 255 characters that DB can only accept. Is there a
way to increase that limit?

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Whats the datatype in the DB? You can make the changes in the DB If it is
Char you can make it Char(8000) , Varchar(max) nvarchar(max) etc.

 

[purple]

Hi

The field data type is a text which can only accommodate 255 characters.

If I will to use Memo, InfoPath forms cannot submit the information.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

This is a limitation in the Infopath. If you want to overcome this you need
to have webservice between the database and the form

 

[purple]

Webservice?

My infoPath form is actually posted in Sharepoint and DB is in my drive

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Yes You need webservice to submit data from Form to DB to overcome this text
limitation. Since Infopath does not allow more than 255 characters to be
inserted into DB directly, you need to use webservice in between form and DB.

 

[Clay Fox]

Hi purple

InfoPath has limitations working with databases that can only be overcome by
using web services.

I would recommend you check out the Database Accelerator product. It has a
free download and provides you with pre-built web services to interact with
your dataabse and gives you a host of other features.

http://www.qdabra.com

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com