Re: [firebird-support] Re: Technical IT specialist Firebird corruption

2020-04-17 Thread John vdW j...@jvdw.nl [firebird-support]
ne give me the script to restore a .fbk file. I kept on getting a file size error. On 17/04/2020 15:17, John vdW j...@jvdw.nl [firebird-support] wrote: Actually I meant the Firebird Server version. Are they the same on Linux and Windows? GBak is designed to make a backup on the fly, even with

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

2020-04-17 Thread John vdW j...@jvdw.nl [firebird-support]
Actually I meant the Firebird Server version. Are they the same on Linux and Windows? GBak is designed to make a backup on the fly, even with many users connected and using the database. No need to shut down. Make sure the gbak-restore creates a new file and does not write into an existing

Re: [firebird-support] Technical IT specialist Firebird corruption

2020-04-17 Thread John vdW j...@jvdw.nl [firebird-support]
ed > Turbocash. Take the firebird database copy it to a linux file system. Use > Playonlinux to open Turbocash and open the database that I've copied from > Windows. It works 100% and I can move it back from Linux to Windows without > any fault. > > > On 17/04/2020 10:56, Joh

Re: [firebird-support] Technical IT specialist Firebird corruption

2020-04-17 Thread John vdW j...@jvdw.nl [firebird-support]
Shane, AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird database from one computer to another, especially from one OS to a different OS. Use the Gbak tool on the original machine to create a backup file. Use the GBak tool on the target machine to restore the backupfile to a

Re: [firebird-support] Question about delay in fetch operation

2019-01-29 Thread John vdW j...@jvdw.nl [firebird-support]
Op 29-01-2019 om 12:45 schreef Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]: >Two last things come to mind... >- a memory issue on the server >What happens if you change page buffers? >- a disk issue on the server >What happens if you leave the original file on the server

Re: [firebird-support] Question about delay in fetch operation

2019-01-29 Thread John vdW j...@jvdw.nl [firebird-support]
Two last things come to mind... - a memory issue on the server What happens if you change page buffers? - a disk issue on the server What happens if you leave the original file on the server and try a copy of the database on a different disk location on a different disk on a different

Re: [firebird-support] Question about delay in fetch operation

2019-01-28 Thread John vdW j...@jvdw.nl [firebird-support]
Op 28-01-2019 om 14:14 schreef Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]: >Look at gstat output >You probably have very long version this particular record Hi Karol. I checked gstat and made a manual sweep of the database, but the problem persists. There are some things

Re: [firebird-support] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...

2019-01-09 Thread John vdW j...@jvdw.nl [firebird-support]
Op 09-01-2019 om 14:14 schreef jonatan.laurit...@yahoo.dk [firebird-support]: My client occassionally receives "connection rejected by remote interface" error while trying to connect to the remote server. I know that incompatibility of versions between gds32.dll/fbclient32.dll and server

Re: [firebird-support] Using FB 3.04 with Delphi 10.2

2018-12-20 Thread John vdW j...@jvdw.nl [firebird-support]
Sounds to me you are using local access to the database, either in the IDE or when running the program (or both). Does the connection params contain a hostname or ipnr? If not, it's probably a local connection. In that case only one process can connect to the db. The IDE (connection component)