Re: [Firebird-net-provider] sweeping

[<car...@te...>]

Hello:

>I've just been trying to write a scheduled program to sweep the database - 
 >am I right in thinking there must be NO active connections in the pool 
for
 > sweeping to be successful??


Seems to be wqorking for me, here is my test case:

FbConnection[] conns = new FbConnection[10];

for (int i = 0; i < conns.Length; i++)
{
	conns[i] = new FbConnection(connectionString);
	conns[i].Open();
}

FbValidation validation = new FbValidation();

validation.Options = FbValidationFlags.SweepDatabase;
validation.Parameters.Database	= @"c:\testdb.gdb";
validation.Parameters.UserName	= "SYSDBA";
validation.Parameters.UserPassword	= "masterkey";
validation.Parameters.DataSource	= "localhost";

validation.Start();

validation.Close();

for (int i = 0; i < conns.Length; i++)
{
	conns[i].Close();
}


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain