Subject Re: [firebird-support] Win XP SP2 - Backup in FB 1.5.3.4870 to Restore in FB 2.0.12748-0
Author Valdir Marcos
Nando, I guess we found the conflict.
FR is using the service of FB 1.5 and I am trying to restore to FB 2 application.
That's why gbak also does not work properly with the -service switch.

Thanks,

Valdir

----- Original Message -----
From: Valdir Marcos
To: firebird-support@yahoogroups.com
Sent: Tuesday, November 28, 2006 10:47 AM
Subject: [firebird-support] Win XP SP2 - Backup in FB 1.5.3.4870 to Restore in FB 2.0.12748-0


Win XP SP2
FlameRobin 0.7.6
FB 1.5.3.4870 (service)
FB 2.0.12748-0 (application)

When I use gbak to backup and restore in FB 1.5.3 there is no problem and when I try to restore in FB 2.0 it also works properly.

When I use flamerobin 0.7.6 to backup and restore in FB 1.5.3 there is no problem, but when I try to restore in FB 2.0 I get this error message:

{
gbak: activating and creating deferred index RDB$PRIMARY26
Database restore cancelled 02:36:37 due to IBPP exception:

*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed

SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements

Engine Code : 335544342
Engine Message :
action cancelled by trigger (2) to preserve data integrity
Cannot deactivate index used by an Integrity Constraint
}

Detail: I have copied fbclient.dll (FB2) to C:\Program Files\FlameRobin, but it made no difference.

(Win XP SP2) May the problem be because I am using FB 1.5 (service) and FB
2.0 (application)?

Can you help me?

Sincerely,

Valdir



[Non-text portions of this message have been removed]