Re: [Firebird-net-provider] Disconnection Problem In Vb.net with Firebird

2016-02-03 Thread Gerdus van Zyl
What I do in my code is issue the database shutdown command(see http://firebirdsql.org/manual/gfix-dbstartstop.html) after closing all connections I can. Imports FirebirdSql.Data.Services Dim s As New FbConfiguration() s.ConnectionString = Me.Connection.ConnectionString s.DatabaseShutdown(FbShutdo

Re: [Firebird-net-provider] Disconnection Problem In Vb.net with Firebird

2016-02-02 Thread Mark Rotteveel
On Tue, 02 Feb 2016 06:57:03 +0100, Jiří Činčura wrote: > Calling `FbConnection.ClearAllPools` is enough. You don't have to call > anything else. Though you might give server few ms to release the file - > it's not guaranteed that closing all connections will immediately > release the file. Maybe

Re: [Firebird-net-provider] Disconnection Problem In Vb.net with Firebird

2016-02-01 Thread SUKHEN DASS
its a single user application which only i am using and i am using this code before IO.File.Replace is being called... which i forgot to include in the codeFor iLoop = 0 To 100            Application.DoEvents()Next On Tuesday, February 2, 2016 11:28 AM, Jiří Činčura wrote: Calling `Fb

Re: [Firebird-net-provider] Disconnection Problem In Vb.net with Firebird

2016-02-01 Thread Jiří Činčura
Calling `FbConnection.ClearAllPools` is enough. You don't have to call anything else. Though you might give server few ms to release the file - it's not guaranteed that closing all connections will immediately release the file. -- Mgr. Jiří Činčura Independent IT Specialist

Re: [Firebird-net-provider] Disconnection Problem In Vb.net with Firebird

2016-02-01 Thread SUKHEN DASS
first i call openconnection method to update some field then i am calling Rename method On Tuesday, February 2, 2016 11:16 AM, SUKHEN DASS wrote: Dear Team, I am facing a problem of connection still in use after clearing the pool and dispose connection objectbut as i close the vb.net

[Firebird-net-provider] Disconnection Problem In Vb.net with Firebird

2016-02-01 Thread SUKHEN DASS
Dear Team, I am facing a problem of connection still in use after clearing the pool and dispose connection objectbut as i close the vb.net application it free the database connection and i can rename the database manually which i want to do at run time Code as belowImports System.DataImports Sys