Subject RE: [firebird-support] Re: Cannot open database file in local hard disk
Author Neil Pickles
In your firebird.conf file, is the following line uncommented (# removed
from the start), if it is add the hash, restart Firebird and try again.



# DatabaseAccess = None



According to the notes in the default firebird.conf file having that
line enabled would mean only files referenced in aliases.conf could be
opened which sounds a lot like your problem.



# Database Paths/Directories

#

# DatabaseAccess may be None, Full or Restrict. If you choose Restrict,

# provide ';'-separated trees list, where database files are stored.

# Relative paths are treated relative to RootDirectory entry

# (see above). Default value 'Full' gives full access to all files

# on your site. To specify access to specific trees, enum all required

# paths (for Win32 this may be something like 'C:\DataBase;D:\Mirror',

# for unix - '/db;/mnt/mirrordb'). If you choose 'None', then only

# databases listed in aliases.conf can be attached.



Regards,



Neil Pickles

Technical Director





CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT

T: 0115 911 1677 M: 07801 316711 F: 0115 959 0959

------------------------------------------------------------------------
--------------

@csyretail <http://www.twitter.com/csyretail>
www.csy.co.uk <http://www.csy.co.uk/> neil@...
<mailto:neil@...>



Registered in England No. 2391386, Vat No GB 520 7385 59, Registered
Address: CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT.
Tel 0115 948 4848, Fax 0115 959 0959.



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 20 February 2018 17:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Cannot open database file in local
hard disk





In every computers I tried there is exactly the same version of Firebird
installed: 2.1.4.18393 32 bits.

The databases where generated with the same version of Firebird. And
remember that if I use an alias, I can open the database. The problem is
when I try to open it using the path of the database file C:\Test\...
.FDB.

I can even generate the database in the same computer (using an alias)
and then I cannot open it using the path of the database file.



-------- Mensaje original --------
Asunto: Re: [firebird-support] Re: Cannot open database file in local
hard disk
De: 'Neil Pickles' neil.pickles@... [firebird-support]
<firebird-support@yahoogroups.com>
<mailto:firebird-support@yahoogroups.com>
A: <firebird-support@yahoogroups.com>
<mailto:firebird-support@yahoogroups.com>
Fecha: 20/02/2018 14:04



You're not switching between 32 bit and 64 bit versions of
Firebird are you?



I'm not sure exactly when the change occurred but I remember
similar issues trying to open a 32 bit generated database with a 64 bit
version of Firebird or vice versa. It's definitely okay with v2.5 but
not sure about v2.1 as it's been some time since I use v2.1 for
anything.



When you open it successfully on another computer, is it the
same bitness of Firebird, 32 bit or 64 bit?



Cheers,



Neil Pickles



From: firebird-support@yahoogroups.com [
mailto:firebird-support@yahoogroups.com]
Sent: 20 February 2018 14:05
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Cannot open database file in
local hard disk





Just a little correction to my message. Where I wrote
firebird.conf, I should have written aliases.conf.



-------- Mensaje original --------
Asunto: Cannot open database file in local hard disk
De: Eduardo <gusedum@...> <mailto:gusedum@...>
A: firebird-support@yahoogroups.com
Fecha: 20/02/2018 10:57

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
<file:///\\%5C%5CSERVERNAME%5CC:%5CTest%5CMYDATABASE.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






<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_ca
mpaign=sig-email&utm_content=emailclient>

Libre de virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_ca
mpaign=sig-email&utm_content=emailclient>







[Non-text portions of this message have been removed]