Hi,
Try recreating the adapter, it should work as first
time.
Paulo Gomes
Em 10-10-2011 11:16, Francesco Giossi escreveu:
Hi,
thanks for your answer.
Well, I tried to remove the transaction,
commenting the code. Well, the behaviour is
exactly the same, with the same error message:
invalid transaction handle(expecting explicit
transaction start).
What kind of transaction is it referring to if
there is no transaction open?
Hi,
I think it has to do with the fact that
the data adapter you are using hasn't the
same scope as the connection, you sould have
in mind tha the DataAdapter has 4 commands
and the ones who perform the changes to the
dataset aren't in the scope of the current
transaction. it goes well in the first
becaus when the commands are created they
get the current transaction assigned.
Hope this helps...
Paulo Gomes
Em 10-10-2011 08:48, Francesco Giossi
escreveu:
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.
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
------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
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
