--- In firebird-support@yahoogroups.com, "turbomenda" <medelski@m...>
wrote:

> --- In firebird-support@yahoogroups.com, "lance8086"

<lance8086@y...>

> > and connect with 'localhost:olympus'
> restore works 10x slower when connected this way. It seems to

actually

> send all the data through the network adapter

Didn't know that, but it makes sense.

> When I use the direct db file path (local server syntax) it only

works

> when called from console, and doesn't work as a scheduled task

I created a bat file that ran gbak using a direct path.

del stew2005.fbk
"C:\Program Files\Firebird\Firebird_1_5\bin\gbak"
d:\firebird.dev\data\stew2005.fdb d:\firebird.dev\stew2005.fbk -user
x -password x
dir stew2005.fbk

added a task, ran it manually. that worked.
scheduled the task for a future time, waited, that worked:

2005/05/11 13:35:00 JobRun d:\firebird.dev>"C:\Program
Files\Firebird\Firebird_1_5\bin\gbak"
d:\firebird.dev\data\stew2005.fdb
2005/05/11 13:35:00 JobRun d:\firebird.dev\stew2005.fbk -
user x -password x
2005/05/11 13:35:00 JobRun d:\firebird.dev>dir
stew2005.fbk
2005/05/11 13:35:00 JobRun 05/11/2005 01:35
PM 999,936 stew2005.fbk

rescheduled the task, logged off (i.e. now showing windows logon on
desktop).
that didn't work:

2005/05/11 13:42:00 JobRun d:\firebird.dev>"C:\Program
Files\Firebird\Firebird_1_5\bin\gbak"
d:\firebird.dev\data\stew2005.fdb
2005/05/11 13:42:00 JobRun d:\firebird.dev\stew2005.fbk -
user x -password x
2005/05/11 13:42:00 JobRun gbak: ERROR: unavailable
database
2005/05/11 13:42:00 JobRun gbak: Exiting before
completion due to errors

changed the bat file to use localhost, rescheduled the task, logged
off.
that worked:

2005/05/11 14:10:00 JobRun d:\firebird.dev>"C:\Program
Files\Firebird\Firebird_1_5\bin\gbak" localhost:stew2005
d:\firebird.dev
2005/05/11 14:10:00 JobRun \stew2005.fbk -user x -
password x
2005/05/11 14:10:00 JobRun d:\firebird.dev>dir
stew2005.fbk
2005/05/11 14:10:00 JobRun 05/11/2005 02:10
PM 999,936 stew2005.fbk

The observation is that firebird requires a console session to use a
direct connect. I've run into similar problems with MSAccess as a
scheduled task. There's no specific reason to require console access
to access local disk files, so barring other reasons it should be a
fixable problem in the code.