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]
