Ah, that path thing makes sense now. The server is running xp-pro, don't
know what the OS is on the computer trying to run my batch file.





-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Daniel Rail
Sent: Friday, August 26, 2005 11:32 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Cannot backup because file is being used


Hi,

At August 26, 2005, 11:18 AM, Raith, Daniel wrote:

> I'm using 1.5.2.4731, super server, and when I try to perform a backup

> I'm getting an error:

> "Error while trying to open file"
> "The process cannot access the file because it is being used by
> another process."

You can't access the same database file, via 2 different pathnames. In
your case, your application references the file via the long pathname,
and you are trying to use GBAK with the short pathname, which Firebird
will recognize as 2 different databases. But, when trying to access the
second pathname, it will find out that it can't because the file is in
use by another application(which could be itself). This is a safeguard
against data corruption.

> Another funny thing about this setup is that the database is in a
> directory that has spaces in the name. Originally I couldn't get the
> backup to work because of it. For example: "c:\my
> data\program\data\database.fdb" which I had to create a backup batch
> file which read something like this.

> Gbak.exe -b "c:\mydata~1\program\data\database.fdb"
> "c:\mydata~1\program\data\database.fbk"

> Otherwise I kept getting an error about specifying multiple sources or

> something. Now I'm getting this other error.

> Any ideas?

I never had a problem with using the pathnames with spaces in them.

Do you have the same error when running GBAK directly from the
command-line, instead of from within a batch file?

Also, which version of Windows are you using?

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links