"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.
|
