Subject Re: [firebird-support] Cannot open database file in local hard disk
Author Oscar_Dar=c3=ado_Perdiguero

//********This is a google translation

Hello Eduardo, in my case what happened was that the path variable of the windows operating system was not updated to the folder where I had firebird and on the other hand, depending on the client, I should put gds32.dll in that folder and / or fbclient.dll too to make sure that any software could access them.



//********Este es el texto original en espa?ol

Hola Eduardo, en mi caso lo que pasaba es que la variable path del sistema operativo windows no estaba actualizada a la carpeta donde yo ten?a firebird y por otro lado, dependiendo del cliente, deb?a poner gds32.dll en esa carpeta y/o fbclient.dll tambi?n para asegurarme que cualquier software pudiera accederlos.



El 20/2/2018 a las 10:57, Eduardo gusedum@... [firebird-support] escribi?:


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


Libre de virus.