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; |
From:
<car...@te...> - 2005-09-13 17:56:40
|
Hello: > 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 What version of the provider are you using ?? if you are using 1.7.1 that should be fixed in CVS ... -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Amanda K. <ak...@fl...> - 2005-09-13 18:02:37
|
Nope. 1.6.3.0 Carlos Guzmán Álvarez wrote: > Hello: > >> 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 > > > What version of the provider are you using ?? if you are using 1.7.1 > that should be fixed in CVS ... > > > > -- > Best regards > > Carlos Guzmán Álvarez > Vigo-Spain > > > ------------------------------------------------------- > SF.Net email is Sponsored by the Better Software Conference & EXPO > September 19-22, 2005 * San Francisco, CA * Development Lifecycle > Practices > Agile & Plan-Driven Development * Managing Projects & Teams * Testing > & QA > Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > |
From:
<car...@te...> - 2005-09-14 14:18:02
|
Hello: > Nope. 1.6.3.0 Hummmm .... can you send to me a test case with a test database included ?? Can you check if it works or not with the v1.7a, please ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |