From: Amanda K. <ak...@fl...> - 2005-09-13 15:59:47
|
I'm trying to run an update of a dataset via a data adapter, and I get this error: An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException' occurred in system.data.dll Additional information: request synchronization error Any ideas of what could be causing it before I continue on my wild goose chase? I've done this many times before with all the same data types, my parameters are all spelled correctly and in the same order as the stored procedure. The error message is just so cryptic. Here's the update code: FirebirdSql.Data.Firebird.FbCommand cmd = new FirebirdSql.Data.Firebird.FbCommand(); cmd = CreateSPCommand("SPADMINMDSCREENINFOUPDATE"); cmd.Parameters.Add("@SCREENID", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "ScreenID"); cmd.Parameters.Add("@OBJECTIVETRACKID", FirebirdSql.Data.Firebird.FbDbType.SmallInt, 4, "ObjectiveTrackID"); cmd.Parameters.Add("@CAPTION", FirebirdSql.Data.Firebird.FbDbType.VarChar, 50, "Caption"); cmd.Parameters.Add("@SCREENTYPE", FirebirdSql.Data.Firebird.FbDbType.VarChar, 15, "ScreenType"); cmd.Parameters.Add("@MESSAGETEXT", FirebirdSql.Data.Firebird.FbDbType.VarChar, 5000, "MessageText"); cmd.Parameters.Add("@QUESTIONID", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "QuestionID"); cmd.Parameters.Add("@OBJECTIVETIMEFRAMEID", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "ObjectiveTimeFrameID"); cmd.Parameters.Add("@BACKENABLED", FirebirdSql.Data.Firebird.FbDbType.SmallInt, 4, "BackEnabled"); cmd.Parameters.Add("@BACKSCREENID", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "BackScreenID"); cmd.Parameters.Add("@NEXTENABLED", FirebirdSql.Data.Firebird.FbDbType.SmallInt, 4, "NextEnabled"); cmd.Parameters.Add("@NEXTSCREENID", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "NextScreenID"); cmd.Parameters.Add("@FINISHENABLED", FirebirdSql.Data.Firebird.FbDbType.SmallInt, 4, "FinishEnabled"); cmd.Parameters.Add("@DIGENABLED", FirebirdSql.Data.Firebird.FbDbType.SmallInt, 4, "DigEnabled"); cmd.Parameters.Add("@DIGDEEPERSCREENID", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "DigDeeperScreenID"); cmd.Parameters.Add("@PROMPTWAITTIME", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "PromptWaitTime"); cmd.Parameters.Add("@PROMPTMESSAGE", FirebirdSql.Data.Firebird.FbDbType.VarChar, 250, "PromptMessage"); cmd.Parameters.Add("@MINDAYS", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "MinDays"); cmd.Parameters.Add("@MAXDAYS", FirebirdSql.Data.Firebird.FbDbType.Integer, 4, "MaxDays"); FirebirdSql.Data.Firebird.FbDataAdapter da = new FirebirdSql.Data.Firebird.FbDataAdapter(); da.UpdateCommand = cmd; da.InsertCommand = cmd; int intError = 0; intError = (int)da.Update(ds, "MDScreenInfo"); <==line that errors out The CreateSPCommand code is as follows: FirebirdSql.Data.Firebird.FbConnection cn = new FirebirdSql.Data.Firebird.FbConnection(); System.Configuration.AppSettingsReader settings = new System.Configuration.AppSettingsReader(); cn.ConnectionString = settings.GetValue("ConnectionString", typeof(string)).ToString(); cn.Open(); FirebirdSql.Data.Firebird.FbCommand cmd = new FirebirdSql.Data.Firebird.FbCommand(); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = StoredProcName; return cmd; |