Hi,
I am using firebird ado.net driver 1.6 to connect to
firebird 1.5 db. In my Data access layer I am calling a procedure and passing
some parameters. I have debugged the parameter values and ran the those
directly on the database using a firebird front end tool. But when I am calling
FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery() method I am getting a
Format Exception which is a .net application. The following is the stack trace
at System.Number.ParseInt32(String s,
NumberStyles style, NumberFormatInfo info)
at System.Int16.Parse(String s,
NumberStyles style, IFormatProvider provider)
at
System.String.System.IConvertible.ToInt16(IFormatProvider provider)
at System.Convert.ToInt16(Object value,
IFormatProvider provider)
at
FirebirdSql.Data.Common.DbValue.GetInt16()
t
FirebirdSql.Data.Gds.XdrStream.Write(DbField param)
at
FirebirdSql.Data.Gds.XdrStream.Write(RowDescriptor descriptor)
at FirebirdSql.Data.Gds.GdsStatement.Execute()
at
FirebirdSql.Data.Firebird.FbCommand.InternalExecute()
at
FirebirdSql.Data.Firebird.FbCommand.executeCommand(CommandBehavior behavior,
Boolean split)
at
FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery()
The stack trace above is of the ado.net driver which shows
its failing in parsing a string to Int32. But all my parameter values are
correct since I have directly tested them on the db.
Please advice
Mahendra Nepali
Desk: +91-22-5642-7140
Mobile:
+919820191887
Email: mahendra.nepali@xxxxxxxxxxxxxxxxxx