You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi all.
First, sorry by my english, not native laguage.
Have the problem with x64 http://ADO.NET Provider.
In operations of adding, changing and deleting data in tables the program throwing exception NullReferenceException.
Exception stack:
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
at FirebirdSql.Data.FirebirdClient.FbTransaction.UpdateTransaction()
at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit()
at FirebirdSql.Data.FirebirdClient.FbCommand.CommitImplicitTransaction()
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
at *myMethod*
For example adding method:
if (dbConnect.State != ConnectionState.Open)
dbConnect.Open();
FbCommand findClientCom = new FbCommand("Select ID FROM CLIENTS WHERE ID='" + ID.ToString() + "'", dbConnect);
FbDataAdapter FDA = new FbDataAdapter(findClientCom);
DataSet ds = new DataSet();
int count = FDA.Fill(ds);
if (count > 0)
{
errStr = "This Client is present";
return false;
}
String insertText = @"INSERT INTO CLIENTS (ID, NET_ID, NAME, LOGIN, PASSWORD, RES_PU, RES_KP, CLUSTER)";
insertText += @" VALUES(@id, @NET_ID, @name, @LOGIN, @password, @RES_PU, @RES_KP, @cluster)";
FbCommand insertCom = new FbCommand(insertText, dbConnect);
insertCom.Parameters.AddWithValue("@id", ID.ToString());
insertCom.Parameters.AddWithValue("@NET_ID", net_id.ToString());
insertCom.Parameters.AddWithValue("@name", name);
insertCom.Parameters.AddWithValue("@LOGIN", login);
insertCom.Parameters.AddWithValue("@password", password);
insertCom.Parameters.AddWithValue("@RES_PU", res_pu);
insertCom.Parameters.AddWithValue("@RES_KP", res_kp);
insertCom.Parameters.AddWithValue("@cluster", cluster.ToString());
insertCom.ExecuteNonQuery();
errStr = "Client " + VikingServer.ushortToStr(ID) + " was added";
return true;
}
catch (Exception ex)
{
errStr = ex.ToString();
return false;
}
My methods are working stable on 32 platform. On x64 tables are changing, but after change i have this exception.
Please help me with this problem.
The text was updated successfully, but these errors were encountered:
Submitted by: Maxim (aquamakc)
Is related to DNET619
Hi all.
First, sorry by my english, not native laguage.
Have the problem with x64 http://ADO.NET Provider.
In operations of adding, changing and deleting data in tables the program throwing exception NullReferenceException.
Exception stack:
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.TransactionUpdated()
at FirebirdSql.Data.FirebirdClient.FbTransaction.UpdateTransaction()
at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit()
at FirebirdSql.Data.FirebirdClient.FbCommand.CommitImplicitTransaction()
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
at *myMethod*
For example adding method:
if (dbConnect.State != ConnectionState.Open)
dbConnect.Open();
FbCommand findClientCom = new FbCommand("Select ID FROM CLIENTS WHERE ID='" + ID.ToString() + "'", dbConnect);
FbDataAdapter FDA = new FbDataAdapter(findClientCom);
DataSet ds = new DataSet();
int count = FDA.Fill(ds);
if (count > 0)
{
errStr = "This Client is present";
return false;
}
String insertText = @"INSERT INTO CLIENTS (ID, NET_ID, NAME, LOGIN, PASSWORD, RES_PU, RES_KP, CLUSTER)";
insertText += @" VALUES(@id, @NET_ID, @name, @LOGIN, @password, @RES_PU, @RES_KP, @cluster)";
FbCommand insertCom = new FbCommand(insertText, dbConnect);
insertCom.Parameters.AddWithValue("@id", ID.ToString());
insertCom.Parameters.AddWithValue("@NET_ID", net_id.ToString());
insertCom.Parameters.AddWithValue("@name", name);
insertCom.Parameters.AddWithValue("@LOGIN", login);
insertCom.Parameters.AddWithValue("@password", password);
insertCom.Parameters.AddWithValue("@RES_PU", res_pu);
insertCom.Parameters.AddWithValue("@RES_KP", res_kp);
insertCom.Parameters.AddWithValue("@cluster", cluster.ToString());
insertCom.ExecuteNonQuery();
errStr = "Client " + VikingServer.ushortToStr(ID) + " was added";
return true;
}
catch (Exception ex)
{
errStr = ex.ToString();
return false;
}
My methods are working stable on 32 platform. On x64 tables are changing, but after change i have this exception.
Please help me with this problem.
The text was updated successfully, but these errors were encountered: