Dumb Question about submitting to a SQL Server DB table

[Anton Federkiewicz]

Whenever I create a new from database form, I cannot submit to database. the
option is never in the drop down list. It works for access db's just fine.

BTW, I can querry the SQL db and obtain the connection but the Submit to:
Database option is never in the pulldown. What gives? Permissions on the DB?

 

[Scott L. Heim [MSFT]]

Hi,

Does your SQL Server table contain any "Image", "Text", "Binary", etc.
types of fields? If so, this would be why the "submit" option is not
available. As a test, create an InfoPath solution from the Customers or
Orders table in the Northwind sample database and see if the Submit option
is available for either of these tables.

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Anton Federkiewicz]

Thank you so much! That was the problem. Table was imported from Access
with the memo data type. Data type nvarchar is not supported by InfoPath!

Do you think I should read the manual? Is this even in the manual? LOL

Thanks again!

 

[Scott L. Heim [MSFT]]

Hi,

That's great to hear!

Technically, this behavior is not an "InfoPath" issue per sé but an
OLEDB/ADO behavior. So if you would like to get more information on data
binding in general, look into ADO.

Take care,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.