Subject | Database on Shared Folder - Cannot attach to password database error |
---|---|
Author | daniele_dll |
Post date | 2008-08-27T13:13:33Z |
Hi to all,
i'm trying to get working an application that uses firebird as data
backend. This application, instead to use a single firebird instance
on a machine to share databases it, use an instance of firebird per
machine (installed as super server) with the database located on a
shared folder.
A week ago, the developer of this application installed to a my
customer this software in a network and on a machine it doesn't work
correctly.
With 1.5 it says "cannot attach to password database" with his
application and isql too ... this is the output:
SQL> CONNECT k:\contab\ken_contab.fdb user SYSDBA password masterkey;
Statement failed, SQLCODE = -902
cannot attach to password database
Using firebird 2.0 or 2.1 i get another error, something like I/O
Error over file !ken!\contab\ken_contab.fdb.
The database file reside on k:\contab\ken_contab.fdb and the shared
folder name is ken on a computer called PC1.
Copying all the stuff on a local folder all works perfectly: no errors!
I know that this application do a strange stuff to use the database,
but he says that he ever installed the application and he never got
problems. The network stuff of the machine works perfectly because
there are a lot of shared folders used by other softwares and used for
datas.
I've looked around, but i haven't found a valid solution for my problem!
note: it's not a permission problem, i think at least, beacuse i
enabled all on the shared folder and it continue to don't work
Thanks to all for the help, this is my first time with firebird and,
even i used other database servers, i can't resolve alone this strange
problem (i combat against it from, at least, 10:00 (GMT+1))
i'm trying to get working an application that uses firebird as data
backend. This application, instead to use a single firebird instance
on a machine to share databases it, use an instance of firebird per
machine (installed as super server) with the database located on a
shared folder.
A week ago, the developer of this application installed to a my
customer this software in a network and on a machine it doesn't work
correctly.
With 1.5 it says "cannot attach to password database" with his
application and isql too ... this is the output:
SQL> CONNECT k:\contab\ken_contab.fdb user SYSDBA password masterkey;
Statement failed, SQLCODE = -902
cannot attach to password database
Using firebird 2.0 or 2.1 i get another error, something like I/O
Error over file !ken!\contab\ken_contab.fdb.
The database file reside on k:\contab\ken_contab.fdb and the shared
folder name is ken on a computer called PC1.
Copying all the stuff on a local folder all works perfectly: no errors!
I know that this application do a strange stuff to use the database,
but he says that he ever installed the application and he never got
problems. The network stuff of the machine works perfectly because
there are a lot of shared folders used by other softwares and used for
datas.
I've looked around, but i haven't found a valid solution for my problem!
note: it's not a permission problem, i think at least, beacuse i
enabled all on the shared folder and it continue to don't work
Thanks to all for the help, this is my first time with firebird and,
even i used other database servers, i can't resolve alone this strange
problem (i combat against it from, at least, 10:00 (GMT+1))