> Question: > > Is provider checking if the same connection string is used and not opening > new connection, uses the already opened one? > > > > Or provider closes connection after rows where fetched? >
it depends how you use the connection. for exemple, if you use it in dbcommand and you call executereader(commandbehavior.closeconnection) after the close of datareader the connection is also close ! [code] fbcommand fbc = new fbcommand("select * from toto", yourConnect); Idatareader rd = fbc.executereader(commandbehavior.closeconnection); while (rd.read()) ; rd.close() // here the connection is close; [/code] so how do you use your connection ? 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider