Hi Dan, --- Dan Cooperstock <[EMAIL PROTECTED]> wrote:
> Argh! This problem just went away on its own. I have no idea why. > > - Dan. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Dan Cooperstock > Sent: March 12, 2007 12:27 PM > To: 'For users and developers of the Firebird .NET providers' > Subject: Re: [Firebird-net-provider] Can't close connection / connection > pool > > Yes, I am doing the backup immediately after closing the connection. The > gist of the code I am executing is as follows: > > connection.Close(); > FbConnection.ClearAllPools(); // or: FbConnection.ClearPool(connection) - no > difference Process.Start("gbak.exe", "-b -user sysdba -pas X -y logfile > sourcedbfile targetbackupfile"); In japanese mailing list, the same problem reported. There are two solutions listed as below URL. http://firebirdsql.org/dotnetfirebird/embedded-firebird-in-dotnet-faq.html 1.Adding connection string "Pooling=false" ->OK. I can use gbak normally. 2.Use FbConnection.ClearPool() or FbConnection.ClearAllPools() method. ->NG. I cannot use gbak. Under embedded environment, 'Pooling=false' have no effect on using Firebird. Then try to use 'Pooling=false'. Regards, KIMURA, Meiji(FAMILY, Given) Tokyo, JAPAN. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
