Hi,
I'm working with Visual studio 2008, C#, firebird 2.1 and
.net provider 2.6.5.0.
I have a problem with FbDataAdapter. Using the dataadapter to
update the records in my datatable, I get an error: "invalid
transaction handle".
The problem never shows up when I use the command for the 1st
time.
From the 2nd time and next, I ALWAYS receive that error.
To keep it simple, here is the code I'm struggling with
(I have a very simple sample project if needed)
What am I doing wrong? This works perfectly with Sql Server
express or server 2008.
----------------------------------------------------------
FbConnection cn = new FbConnection(ConnectionString);
cn.Open();
FbTransaction tr =
cn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
da1.SelectCommand.Connection = cn;
da1.SelectCommand.Transaction = tr;
da1.Update(ds);
tr.Commit();
MessageBox.Show("OK!","", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
tr.Rollback();
MessageBox.Show("ERROR\r\n" + ex.Message, "",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cn.Close();
tr.Dispose();
----------------------------------------------------------
where...
da1 is a FbDataAdapter
ds is my dataset containing only one datatable
the stack trace is:
in
FirebirdSql.Data.FirebirdClient.FbDataAdapter.Update(DataRow[]
dataRows, DataTableMapping tableMapping) in
C:\Users\Jiri\Desktop\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbDataAdapter.cs:riga
455
in
System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable
dataTable, DataTableMapping tableMapping)
in System.Data.Common.DbDataAdapter.Update(DataSet
dataSet, String srcTable)
in System.Data.Common.DbDataAdapter.Update(DataSet
dataSet)
in DataSetFireBird.Form1.button1_Click(Object sender,
EventArgs e) in C:\Documents and
Settings\Joss\Documenti\Comelit\_Codice\DataSetFireBird\DataSetFireBird\Form1.cs:riga
63
I even tried the workaround and the solution proposed here
but, when it's about the workaround, it doesn't work.
On the other hand, I don't get how to apply the fix proposed
by Jiri.
The last but not least, the error NEVER shows up when using
the server mode, but is ALWAYS shown when using the embedded
version. The difference is, obviously, in the connection string
to the database.
here are the two connection strings
SERVER: private String ConnectionString =
@"Server=localhost;User=SYSDBA;Password=masterkey;Database=C:\Documents
and Settings\Joss\Documenti\Test\db\test.FDB";
EMBEDDED: private String ConnectionString =
@"User=SYSDBA;Password=masterkey;Database=C:\Documents and
Settings\Joss\Documenti\Test\db\test.FDB;server
type=Embedded;charset=UTF8;";
In my environment is supposed to use the embedded version
(it's a redistributable application).
Thanks in advance
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
