Hi,

> I am ocassionally seeing this error at various of my customer sites.
> It happens to sites running IB5.x and Firebird 1.0x. I happens to 2
> completely different applications. These sites are all running
> various flavours of Windows from NT to 2003. Nothing shows in the
> interbase.log file.
>
> The complete text of the message is:
>
> I/O error for file
> "D:\AURORA\AURORAIMAGING.GDB"
> Error while trying to read from file
> The process cannot access the file because another process has locked a
> portion of the file."
>
> On the IB sites I can understand how it might happen. A virus scan or
> system backup might be opening the file.

Don't do that!! Ever!! Remove GDB files from the backup/virus
scan processes. This can cause database corruptions.

>But my understanding was
> that the Firebird service locked the GDB files for exclusive use as
> soon as the DB was opened.
>
> Anyone had any experience with this error?

One reason might be that you are connecting via:

c:\path
and
c:path

in different connections.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com