At 11:01 PM 25-09-01 -0700, you wrote:

> >
> >Perhaps, while we're on the subject, another reader would care to confirm
> >or demolish my impression that if one user accesses a file on the server
> >from the server, which file is also accessed by other users from client
> >machines, then he must prefix the filename with localhost: otherwise
> >corruption can occur.
>
>I was under the impression that the source of that corruption, the
>"connection string bug" had been fixed in one of the later Firebird releases.
>
>If this is NOT so, I would really like to hear about it.

To clarify, the 'connection string bug' was not related to remote users connecting to a database which was being accessed by a local user.

It relates to omitting the backslash after the drive identifier in the physical path string and the corruption will occur whenever there are concurrent users, at least one of which omits the backslash whilst one or more others include it.

i.e. one user connects with c:databases\mydb.gdb or ourserver:c:databases\mydb.gdb
while others connect with c:\databases\mydb.gdb or ourserver:c:\databases\mydb.gdb

Firebird 1 will simply reject path strings with the missing backslash - not certain whether it is implemented in the current Beta2 build though.

rgds,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________