As you say, that sounds to be related, but unfortunately I found that
line commented as it is by default. Every line related with
DatabaseAccess is commented. I even compared the whole file
firebird.conf with the one in another computer with the same Windows (in
which one I don't have the problem), and they are identical.
I thought of restarting Firebird anyway, but I can´t do it now because
there are people working. I will do it later.
-------- Mensaje original --------
*Asunto: *Re: [firebird-support] Re: Cannot open database file in local
hard disk
*De: *'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
<firebird-support@yahoogroups.com>
*A: *<firebird-support@yahoogroups.com>
*Fecha: *20/02/2018 14:49
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/> n...@csy.co.uk
<mailto:n...@csy.co.uk>
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.pick...@csy.co.uk [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 <guse...@gmail.com> <mailto:guse...@gmail.com>
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]
---
El software de antivirus Avast ha analizado este correo electrónico en busca de
virus.
https://www.avast.com/antivirus
