I get an IscException error when I run this code a second time. Note that it works perfect the first time but not the second.
DataTable dt = new DataTable();
command.CommandType = CommandType.Text;
command.Connection = connection;
command.Connection.Open(); // open the connection
dt.Load(command.ExecuteReader(CommandBehavior.CloseConnection)); // close the connection
The command object shows:
{FirebirdSql.Data.FirebirdClient.FbCommand }
[FirebirdSql.Data.FirebirdClient.FbCommand]: {FirebirdSql.Data.FirebirdClient.FbCommand}
base {System.ComponentModel.Component}: {FirebirdSql.Data.FirebirdClient.FbCommand}
CommandText: "SELECT * FROM booking WHERE customer_id = @id"
CommandTimeout: 0
CommandType: Text
Connection: {FirebirdSql.Data.FirebirdClient.FbConnection}
DesignTimeVisible: true
Parameters: {FirebirdSql.Data.FirebirdClient.FbParameterCollection }
Transaction: null
UpdatedRowSource: Both
And the connection shows:
FirebirdSql.Data.FirebirdClient.FbConnection}
[FirebirdSql.Data.FirebirdClient.FbConnection]: {FirebirdSql.Data.FirebirdClient.FbConnection }
base {System.ComponentModel.Component}: {FirebirdSql.Data.FirebirdClient.FbConnection}
ConnectionString: "user=DBdF;password=#12s#;database=C:\\EventManager\\Data\\EVENTMANAGER.FDB;datasource=localhost;port=13050;dialect=3;charset=NONE;connection lifetime=0;connection timeout=15;pooling=true;packet size=8192;server type=0"
ConnectionTimeout: 15
Database: "C:\\EventManager\\Data\\EVENTMANAGER.FDB"
DataSource: "localhost"
ServerVersion: "WI-V6.3.3.4870 Firebird 1.5"
State: Open
Is this a bug in Firebird provider?
Regards, Jon.
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
