Subject Re: [firebird-support] Problem with FB 2.0.5.13206 32 bit on SBS2008x64
Author Tony Christiansen
Helen Borrie wrote:
>
>
> At 12:26 PM 20/03/2009, you wrote:
> >Hi all
> >

> >gbak: ERROR:I/O error for file "C:\BOOKSYS\ArtistTek\ARTISTTEK.GDB"
> >gbak: ERROR: Error while trying to open file
> >gbak: ERROR: The process cannot access the file because it is being
> >used by another process.
> >

> There is no 64-bit version of Fb 2.0.x. The 32-bit should run fine on a
> 64-bit server.
>
> This looks very much like two *server instances* trying to access the
> same database simultaneously. You definitely need to check and make sure
> that you don't have two firebird servers running on that machine (don't
> overlook an embedded Firebird application - it's a server too!) (Or an
> InterBase running there).
>
> Make sure gbak isn't trying to connect via an embedded server (or vice
> versa, the app uses an embedded server and you're trying to run gbak
> concurrently).
>
> >(FB has been running absolutely rock solid with my applications on this
> >client for the last 5 years until now.)
>
> So something here is different. ;-) And not as it ought to be. "Last 5
> years" indicates that they've been running v.1.5 previously - is this
> first time up with 2.0.x?
>
> ./heLen

Hi Helen

No embedded server apps and only one FB server installed that I can see.

We upgraded to FBv2.0 12 months ago with no problems. Only change to the
installation has been their recent move to 64bit SBS on the main server.

They do have a workstation acting as an accounting server running FBv2.0
on it. If someone using that workstation accesses the database on the
main server could it confuse FB. I open each database with the correct
server name so hope that each FB server is kept separate. Have I just
been very very lucky with this for the past years :)

I did have a copy of fbclient.dll in the gbak folder. I have since
deleted it but 3 out of 4 databases backed up fine even when it was there.

Have you heard of antivirus scanning getting in the way maybe.

Thanks
Tony