| Subject | Cannot open database file in local hard disk |
|---|---|
| Author | Eduardo |
| Post date | 2018-02-19T23:31:47Z |
Hello:
I use Firebird 2.1 and in some computers I cannot open a
database file which is in the local hard disk.
For example, let's suppose I have the database
C:\Test\MYDATABASE.FDB and I try to open it with IB_SQL (from
IBObjects).
If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable
database".
If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable
database".
If I modify firebird.conf creating the alias
MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can
open the database.
In almost every computer with any Windows version (XP, 7, 10,
2003, 2008, 2012, 2016) I can open the database using every one
of the four methods, but in some computers the first three
methods return "unavailable database" and I can open the
database only using an alias. Now I am having the problem in a
computer with Windows Server 2008 R2 Standard with Service Pack
1, but I remember having this problem in other computers from
time to time.
Any ideas of which may be the reason? ... and the solution?
Thanks in advance. Regards
Eduardo
