Re: [Firebird-net-provider] Command must have a valid transaction

[Thomas B. <bie...@gm...>]

Hello everyone!

I'm experiencing the same problem and tried to reproduce Carlos' working 
code (see below).

It's not working for me (using Version 1.5RC3). Could this be related to 
"implicit transaction support"? (400...@te...)

Best Regards,

Thomas


   FbConnection connection = new FbConnection(...);
   connection.Open();

   string sql = "select * from employee";

   DataSet employeeDS = new DataSet("Employee");
   FbDataAdapter adapter = new FbDataAdapter();

   FbCommand selectCommand = new FbCommand(sql, connection);
   selectCommand.CommandType = CommandType.Text;
   adapter.SelectCommand = selectCommand;

   adapter.Fill(employeeDS, "employee");

   "Command must have a valid Transaction." :-(