Re: [Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F3...@te......
>
> I'm going to release packages for 1.1 later this week.
>

Hola Carlos,
the exe package seems to be broken...
By the way I succesfully compiled the new sources.

Now I can't understand what's happening with the following simple code:

  public short Login(string LoginName, string Password)
  {
   FbConnection Conn = new
FbConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
   Conn.Open();
   FbTransaction Trans = Conn.BeginTransaction();

   short UserID = 0;

   try
   {
    FbCommand Cmd = new FbCommand("EXECUTE PROCEDURE
SP_LOGIN(@IN_LOGIN_NAME, @IN_PWD)", Conn, Trans);

    Cmd.CommandType = CommandType.StoredProcedure;

    Cmd.Parameters.Add("@IN_LOGIN_NAME", FbDbType.VarChar).Value =
LoginName;
    Cmd.Parameters.Add("@IN_PWD", FbDbType.VarChar).Value = Password;
    Cmd.Parameters.Add("@OUT_ID", FbDbType.SmallInt).Direction =
ParameterDirection.ReturnValue;

    Cmd.ExecuteNonQuery();


    if (Cmd.Parameters["@OUT_ID"].Value != DBNull.Value)
    {
     UserID = (short)Cmd.Parameters["@OUT_ID"].Value;
    }
   }
   finally
   {
    Trans.Commit();
    Conn.Close();
   }

   return UserID;
  }


I always get the following exception on Cmd.ExecuteNonQuery():

[NullReferenceException: Object reference not set to an instance of an
object.]
   FirebirdSql.Data.Firebird.FbParameter.setFbDbType(Object value) +5
   FirebirdSql.Data.Firebird.FbParameter.set_Value(Object value) +18
   FirebirdSql.Data.Firebird.FbCommand.SetOutputParameters() +224
   FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery() +112
   Acronimio.Lasting.LMTSecurity.Login(String LoginName, String Password) in
d:\webroot\Lasting\components\Security.cs:27
   ASP.login_aspx.btnLogin_OnClick(Object Sender, EventArgs e) +74
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277

Any idea?

Thank you very much.

Ciao,
Alessandro Petrelli.