> I only have select transactions on two databases
>
> I tried Gfix two_phase all
> But get this error message
>
>

D:\sites\fleetselect\data\FleetSelect>D:\sites\fleetselect\data\FleetSelect\
GFix

> .EXE -two all -user SYSDBA -pas qlw12x!
> localhost:D:\sites\fleetselect\data\Fle
> etSelect\FLEETSELECT.GDB
> Could not reattach to database for transaction 15474.
> Original path: 192.168.0.2:D:\sites\fleetselect\data\atlx\atlx.gdb
> Enter a valid path:

Seems it had another database attached for that transaction.

I think you should be able to force it to rollback, check the gfix
docs on that.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com