firebird-net-provider

[Firebird-net-provider] Unhandled Exception in FbValidation

[nschoemaker <nsc...@xp...>]

Hi,

Using the 1.7 version.

Calling the Execute method of an FbValidation throws an Unhandled exception.
This is the code i used:

public static void ValidateDatabase()
{
  FbValidation val = new FbValidation();
  val.ConnectionString = InitConnectionString(SysdbaUser,SysdbaPassword);
  val.Options = FbValidationFlags.CheckDatabase; -------------> Also tried 
Full

  val.Execute();
}

The connection string was:
"Port Number=3050;Pooling=True;User Id=SYSDBA;Data 
Source=localhost;Database=coach3;Max Pool 
Size=5;Charset=NONE;Password=@UePFa[zb;Min Pool Size=0;Dialect=3"

'DefaultDomain': Loaded 
'c:\windows\microsoft.net\framework\v1.1.4322\mscorlib.dll', No symbols 
loaded.
'CASTester': Loaded 'D:\projects\Coach 3\CASTester\bin\Debug\CASTester.exe', 
Symbols loaded.
'CASTester.exe': Loaded 'd:\projects\coach 
3\castester\bin\debug\xploration.coach3.dll', Symbols loaded.
'CASTester.exe': Loaded 
'c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll', No 
symbols loaded.
'CASTester.exe': Loaded 'd:\projects\coach 
3\castester\bin\debug\xploration.coach3.servicecontrol.dll', Symbols loaded.
'CASTester.exe': Loaded 
'c:\windows\assembly\gac\system.windows.forms\1.0.5000.0__b77a5c561934e089\system.windows.forms.dll', 
No symbols loaded.
'CASTester.exe': Loaded 
'c:\windows\assembly\gac\firebirdsql.data.firebird\1.7.0.22450__fa843d180294369d\firebirdsql.data.firebird.dll', 
No symbols loaded.
'CASTester.exe': Loaded 
'c:\windows\assembly\gac\system.data\1.0.5000.0__b77a5c561934e089\system.data.dll', 
No symbols loaded.
'CASTester.exe': Loaded 
'c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.xml.dll', 
No symbols loaded.
An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException' 
occurred in firebirdsql.data.firebird.dll
Additional information: no information of this type available for object 
specified

Unhandled Exception: FirebirdSql.Data.Firebird.FbException: no information 
of this type available for object specified
at FirebirdSql.Data.Firebird.Services.FbService.StartTask()
at FirebirdSql.Data.Firebird.Services.FbValidation.Execute()
at Xploration.Coach3.Database.CoachConnectionProvider.ValidateDatabase() in 
d:\projects\coach 
3\services\xploration.coach3\coachconnectionprovider.cs:line 275
at CASTester.AppContr.Main() in d:\projects\coach 
3\castester\appcontr.cs:line 14The program '[2632] CASTester.exe' has exited 
with code 0 (0x0).

Tia,
Nico Schoemaker.

Re: [Firebird-net-provider] Unhandled Exception in FbValidation

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

Hello:

  > public static void ValidateDatabase()
> {
>   FbValidation val = new FbValidation();
>   val.ConnectionString = InitConnectionString(SysdbaUser,SysdbaPassword);
>   val.Options = FbValidationFlags.CheckDatabase; -------------> Also tried 
> Full

In first place (iw ill try to do more tests later today) CheckDatabase 
looks to be the only option that didn't work, i think i will be removing 
it, can you give a try using ValidateDatabase instead ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Unhandled Exception in FbValidation

[nschoemaker <nsc...@xp...>]

Hi Carlos,

> it, can you give a try using ValidateDatabase instead ??

ValidateDatabase doesn't throw an exception, but i noticed that my 
eventhandler for the
ServiceOutput isn't triggerd.

Code:

val.ServiceOutput += new ServiceOutputEventHandler(DoServiceOutput);
val.Execute();

This eventhandler never get's called:

private static void DoServiceOutput(object sender, ServiceOutputEventArgs e)
{
  if(fLogStrm == null)
    return;
  fLogStrm.WriteLine(e.Message);
}

TIA,
Nico Schoemaker 

Re: [Firebird-net-provider] Unhandled Exception in FbValidation

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

Hello:

>ValidateDatabase doesn't throw an exception, but i noticed that my 
>eventhandler for the
>ServiceOutput isn't triggerd.
>
It can be that it doesn't have output, but, can you check if the VErbose 
property is set to true ??


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"Todos somos muy ignorantes. Lo que ocurre
es que no todos ignoramos las mismas cosas." Albert Einstein

Re: [Firebird-net-provider] Unhandled Exception in FbValidation

[nschoemaker <nsc...@xp...>]

Hi Carlos,

> It can be that it doesn't have output, but, can you check if the VErbose 
> property is set to true ??

I'm using the 1.7 version.
I cant access a property named verbose in the the FbValidation class.

The only public property's i got are:
-ConnectionString
-Options
-QueryBufferSize
-State

hth,
Nico Schoemaker. 

Re: [Firebird-net-provider] Unhandled Exception in FbValidation

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

Hello:

>I'm using the 1.7 version.
>I cant access a property named verbose in the the FbValidation class.
>
Next time i should review that first :P, if it doesn't have the Verbose 
property is because it doesn't have output.

Huummm The ServiceOutput event is in the base class but not all the 
Services have output,
i should think on something to avoid confusions with this.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"Todos somos muy ignorantes. Lo que ocurre
es que no todos ignoramos las mismas cosas." Albert Einstein

Re: [Firebird-net-provider] Unhandled Exception in FbValidation

[nschoemaker <nsc...@xp...>]

Hi Carlos,

thx for your quick reply's :)

> Next time i should review that first :P, if it doesn't have the Verbose 
> property is because it doesn't have output.
>
> Huummm The ServiceOutput event is in the base class but not all the 
> Services have output,
> i should think on something to avoid confusions with this.

Yes i agree ;-)
 Maybe removing the event from the baseclass and expose the ServiceOutput 
functionality through an interface ? (ie, IServiceOutput)

In the help file under the FbValidation class i noticed this example and 
assumed in the 1.7 version this code was replaced by the ServiceOutput 
event:

validationSvc.Start();

string lineOutput;
while((lineOutput = validationSvc.GetNextLine()) != null)
{
    Console.WriteLine(lineOutput);
}

hth,
Nico Schoemaker.