Hello,
I am having an interesting problem with browser based InfoPath forms in SharePoint 2007. For some reason the file attachment control is not working any more. It was working fine in July, but now it will not allow file attachments over a few kb.
I tried a 34KB file and I get the error below, a 2KB file works fine.
Unable to connect to SQL Server session database. The connection string (server='SPDB', database='SharedServices1_DB') was returned by an instance of the IPartitionResolver type 'Microsoft.Office.Server.Administration.SqlSessionStateResolver,
Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. at System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection conn, Exception e)
at System.Web.SessionState.SqlSessionStateStore.HandleInsertException(SqlConnection conn, Exception e, Boolean newItem, String id)
at System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem)
at System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
The form loads fine as a browser based form but then has the above error when I try to attach a file (Modified web config so I would get the full error). Also, even though the attachment control is in InfoPath it is SharePoint that is returning
the error.
- I have checked 'maxRequestLength' in the web config and it is set to 51200, so that does not seem to be the problem.
- I also checked machine.config and I didn't see anything there (although I rarely look at that so I'm not sure I would recognize a problem if I saw it.)
- I also saw this post where Tomas suggested that db_owner and public permissions be added to SQL server for the web front end machine.
That also did not help.
- I played around with many different InfoPath settings in Central Admin, but that didn't help either.
- Uninstalled .Net 4.0, in case a server update caused a change that broke things.
- Tried a new form with only an attachment control on a different site within the same site collection, same error. (So it doesn't seem to be a problem in the form).
I cannot think of anything that has changed, other than server updates. Please let me know if you have any ideas.
Thanks,
Eric
View Complete Post