[firebird-support] fbclient: What to do after "Error readin / writing data to/ from the connection"

2017-07-25 Thread Marsupilami79 marsupilam...@gmx.de [firebird-support]
Hello,

some of my client seemingly have a faulty network and get the following errors 
ocassionally when running my program while it tries to execute a query:

Error writing data to the connection.
Error reading data from the connection.

What do I have to do from an fbclient point of view to gracefully close the 
connection and release all ressources? Is this even the right list to ask these 
questions?

With best regards,

Jan



Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)

2017-07-25 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello robert,

Tuesday, July 25, 2017, 4:32:12 PM, you wrote:

> When I try to unpack it using the following command:

> c:\Program Files\Firebird..\bin\gback.exe -c VAS.bak VAS.fdb

1. Make sure the server is running.
2. You need the file path and, if using Classic mode, the hostname.

> This produces errors:

> gbak: Error: unavailable database VAS

> gbak: Error: failed create database VAS

> gbak: Error: Exiting before completion due to errors.


> when I do the same on my linux box

> sudo gbak -c VAS.bak vas_db/VAS.fdb

> this seems to work fine (alltough i can not use the result)

> can somebody please tell me, how to unpack that file on windos?

Let's assume you want the database to be in a directory called
"vas_db" and you have created this directory on drive D.  For
simplicity, let's say you have placed the backup there as well.

The backup is just a FILE so you don't need the host name for that.
You are restoring to a DATABASE and for that you need a host name on
Classic.

You want

gbak -c d:\vas_db\/VAS.bak localhost:d:\vas_db\VAS.fdb -user sysdba
-password yourpwd

The default sysdba password on a new installation is masterke, in case
you don't know that already.

The drive MUST be one that is physically connected to the host box.
It can't be a share or anything like that.

Helen