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

[<car...@te...>]

Hello:

> Does anyone have any idea what I am doing wrong?

I have tested it with this code:

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

string sql = "select * from divisacb";

DataSet	m_patientListDS	= new DataSet("PatientList");
FbDataAdapter m_patientAdapter = new FbDataAdapter();
			m_patientAdapter.TableMappings.Add("Table", "RS_PatientLevel");

FbCommand patientCommand = new FbCommand(sql, connection);
patientCommand.CommandType = CommandType.Text;	
m_patientAdapter.SelectCommand = patientCommand;

m_patientAdapter.Fill(m_patientListDS);

connection.Close();

having no problem, tell to me if it's no correct.

Which version of the .NET Data Provider are you using ?? Can you send a 
test case ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain