Re: Infopath 2007 Ink Picture with SQL Server 2008

virtuosojoel — Tue, 20 May 2014 12:54:12 GMT

Since I couldn't get InkPicture to work with Infopath, I wrote my own form using ADODB with a Userform in Excel.

Infopath 2007 Ink Picture with SQL Server 2008

virtuosojoel — Wed, 14 May 2014 15:14:01 GMT

Hi, I'm relatively new to Infopath. I'm using:

Infopath 2007
SQL Server 2008
Laptop with touchscreen

I'm trying to create an Ink Picture control to capture physical signatures on the touchscreen.

In the database I've tried these data types so far: image, ntext, nvarchar(MAX), varbinary(MAX).

All of these types are listed as "simpleType" when Infopath links to the database.

When I try to create an Ink Picture control in a new form, I recieve the error: "A picture control whose picture is included in the form must be bound to a non-repeating field with a picture data type."

I cannot change the field's data type within Infopath. There is no such data type as "picture" as shown in the error message, and I cannot find anything which will force Infopath to recognise the fields as base64 compatible.

I am at a loss with this. Is there a way to use Infopath to save drawn signatures into a SQL table?

Thanks,

Joel

Newbie Questions

Re: Infopath 2007 Ink Picture with SQL Server 2008

Infopath 2007 Ink Picture with SQL Server 2008