Subject | File is in use error in Firebird 2.0.1 SS in Windows Vista HB |
---|---|
Author | marc_guillot |
Post date | 2007-10-25T18:21:27Z |
Hello.
I have installed a Firebird 2.0.1 SuperServer in Windows Vista (Home
Basic), and I have problems in concurrent access.
I can connect to a database only from one computer at a time. If I
connect to a database from one computer, then I can open as many
connections there as I want, but when I try to open a new connection
from another computer I get this error : I/O Error for file
".....\Database.fdb", Error while trying to open file, El proceso no
tiene acceso al archivo porque esta siendo utilizado por otro proceso
(File is in use by another process). If I close all connections from
first computer, then I can open with no problems connections to
database in second computer (but after that, every time I try to
connect to database in first computer, I will get the File is in use
Error).
Both computers connects trough TCP/IP.
I have removed Firebird 2.0.1 and installed Firebird 2.0.3 Superserver
with the same problem. Then I have removed it and installed Firebird
2.0.3 Classic Server. Now it runs like a charm. But what was the
problem ?. If possible, I prefers 2.0.1 SuperServer, because I don't
want to have differents versions and flavours in my costumers.
Thank you.
I have installed a Firebird 2.0.1 SuperServer in Windows Vista (Home
Basic), and I have problems in concurrent access.
I can connect to a database only from one computer at a time. If I
connect to a database from one computer, then I can open as many
connections there as I want, but when I try to open a new connection
from another computer I get this error : I/O Error for file
".....\Database.fdb", Error while trying to open file, El proceso no
tiene acceso al archivo porque esta siendo utilizado por otro proceso
(File is in use by another process). If I close all connections from
first computer, then I can open with no problems connections to
database in second computer (but after that, every time I try to
connect to database in first computer, I will get the File is in use
Error).
Both computers connects trough TCP/IP.
I have removed Firebird 2.0.1 and installed Firebird 2.0.3 Superserver
with the same problem. Then I have removed it and installed Firebird
2.0.3 Classic Server. Now it runs like a charm. But what was the
problem ?. If possible, I prefers 2.0.1 SuperServer, because I don't
want to have differents versions and flavours in my costumers.
Thank you.