InfoPath Dev

I have a document type that I believe Ernesto helped me set up. I am attempting to update the database connection string. The new connection string validates, but am unable to save the change because I am receiving a validation error.

I do not recall how this document type was originally set up without the table having an identity column. See the attached image for illustration.

Hi DC Forms,

Do you have one of the fields marked as "Key"? If not, that could explain why you're getting the error message. We present that message to prevent people from creating an incorrect mapping since you will need a key field.

I will forward this to Ernesto and ask him to contact you first thing Monday.

More soon,

Can you compare the design of the new and the original tables? I'm guessing that the original table had a primary autoincrement key, and thus the SQL mapping was saved without a key defined in DAT.

Let us know what you find. Thanks.

Ernesto,

You are correct. The SQL Server Import and Export Wizard did not maintain the Primary Key and (Is Identitiy) setting for the ID column when I migrated the database.

FYI, after making the database changes I did have to exit the the document type settings in DAAT (going back to the catalog) and then went back in to the document type database settings to change and save the new connection string. It appears the database configuration is cached in DAAT- I kept getting the error when trying to save the new connection string after the database changes were made. I had the document type's database tab open as I made the database changes.