Infopath forms with SQL Server

• PHXHoward

  SSCrazy Eights

  Points: 8389

  More actions

  August 27, 2010 at 11:34 am

  #228379

  Hi, are there any good tutorials for creating SQL Server data entry forms in Infopath 2007?

  I create a data connection, select a table, add some data rows to the form's query box and then preview the form.

  After hitting query, the form displays the records in the table but when I change one and hit submit, it returns this message:

  Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets.

  I was hoping to find some documentation to avoid isues like this.

  Google does not have anything about this that I can tell. Does anyone know a good tutorial source?

  Also is Infopath 2007 the best way to create data entry forms? Something like Data Access Pages using IE would work better but there does not appear to be anything like that anymore.