Ok all of my routines that access the database do call the dispose method. The problem still seems to exist. There is only 1 database connection to the database right now but there are multiple threads accessing the Connection. Does the FBConn object not allow multi-threading?
John Smith ----- Original Message ----- From: "Carlos Guzmán Álvarez" <[EMAIL PROTECTED]> To: "For users and developers of the Firebird .NET providers" <firebird-net-provider@lists.sourceforge.net> Sent: Tuesday, October 03, 2006 3:40 PM Subject: Re: [Firebird-net-provider] deadlock Hello: > Well the application that I have developed is a multi threaded application > that is continuously executing SQL Commands. Are you using one connection per thread ?? What Isolation Levels are you using ?? > Are commands automatically > committed once the dispose command is called? > No you should be calling Dispose manually when they are no more needed to ensure resources used by the commands are being released on the server. -- Carlos Guzmán Álvarez Vigo-Spain ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
