Re: [firebird-support] Cannot open database file in local hard disk

[Oscar Darío Perdiguero d.perdigu...@yahoo.com.ar [firebird-support]]

//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.

Regards

Dar?o

//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.

Saludos

Dar?o

El 20/2/2018 a las 10:57, Eduardo guse...@gmail.com [firebird-support] 
escribi?:
>
> 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
>
>
> 
>  
>   Libre de virus. www.avast.com 
> 
>  
>
>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> 

Re: [firebird-support] Cannot open database file in local hard disk

[Marsupilami79 marsupilam...@gmx.de [firebird-support]]

Hello Eduardo,

you might want to check the setting DatabaseAccess in firebird.conf. If
it is set to None or Restrict for some reason the behaviour you describe
can happen.

Best regards,

Jan

Am 20.02.2018 um 14:57 schrieb Eduardo guse...@gmail.com [firebird-support]:
>  
>
> 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
>
>
> 
>   Libre de virus. www.avast.com
> 
>
>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> 

Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

On Mon, Feb 19, 2018 at 9:16 AM, hv...@users.sourceforge.net
[firebird-support]  wrote:

>
>
> ---In firebird-support@yahoogroups.com,  wrote :
> >
>
> > files/firebird/intl/libfbintl. so
> /*The icu files are not in the distributed tar */
>
>   This is wrong structure, where do you get it ?
>

Trying  to use the same structure from Windows:

libclient in on folder and then the plugins and int folders relative to
this.



>
>   For correct structure look at android build here
>
> https://github.com/FirebirdSQL/firebird/releases/
> download/R3_0_3/Firebird-3.0.3.32900-0.arm.tar.gz
>
>   It contains subfolders :
> /bin with executables (you don't need it for embedded),
> /lib with libfbclient.so (you don't have it and this is the reason for
> errors you see)
>
>
I will try that later.

Regards
jGoncalves

Re: [firebird-support] Cannot open database file in local hard disk

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

20.02.2018 0:31, Eduardo guse...@gmail.com [firebird-support] wrote:
> 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.

   Check that disk letter you used is really "C" and not just something that 
looks 
similar, like, for example, "С".


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: FB3 Embedded on Android

[peshk...@mail.ru [firebird-support]]

Jorge, regarding access to /data/local/tmp. Some time ago when I was making 
Android port this was close to recommended place for tmp files on android. See 
for example 
https://stackoverflow.com/questions/21105281/where-is-the-tmp-in-android 
https://stackoverflow.com/questions/21105281/where-is-the-tmp-in-android

Surpise but currently I also can't access that directory any more, even on 
physically same device which was used for tests that time. I.e. appears to be 
SW upgrade result. 

The problem is where should we place tmp files (including lock files and other 
shared files) now. Application cache may be at any moment cleaned which will 
cause problems if fb engine is running. Do you have better ideas than 
/storage/emulated/legacy/firebird ?

Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

On Mon, Feb 19, 2018 at 10:04 AM, Jorge Gonçalves 
wrote:

>
>
>
>
>>
>>   For correct structure look at android build here
>>
>> https://github.com/FirebirdSQL/firebird/releases/download/
>> R3_0_3/Firebird-3.0.3.32900-0.arm.tar.gz
>>
>>   It contains subfolders :
>> /bin with executables (you don't need it for embedded),
>> /lib with libfbclient.so (you don't have it and this is the reason for
>> errors you see)
>>
>>
> I will try that later.
>

My mistake to assume that the structure are the same from windows.

Keeping the original structure does the job.

But I think that the FB team should work on this, since the process of
installing on Android is not a easy job.

Because there are a fixed structure is impossible to use the lib folder to
install the native libraries.





Thanks



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: [firebird-support] Re: FB3 Embedded on Android

[hv...@users.sourceforge.net [firebird-support]]

---In firebird-support@yahoogroups.com,  wrote :
> 
 > setting the FIREBIRD_LOCK to app/cache  solve the problem. 
  Noted, thanks


 > Now I have get privilege error but this time is a FB error.  
 > 
 > FB is working now.
 > > SQL Message : -607 > This operation is not defined for system tables.
 > 
 > Engine Code: 335544351
 > Engine Message :
 > unsuccessful metadata update
 > CREATE TABLE TMP_INSERT_TEST failed
 > There is no privilege for this operation
  
  Embedded engine doesn't verify user password but it still requires correct 
user 
name and checks all SQL operations against it. I guess, you provide no user 
name 
and engine uses OS user name. Obviously, it have no SQL privileges.

  So, provide correct user name when attaching to database (password could be
omitted in embedded case).

Regards,
Vlad

Re: [firebird-support] Re: Cannot open database file in local hard disk

[Eduardo guse...@gmail.com [firebird-support]]

Good news!!!
With the tip of Neil I found a strange solution. I did the following:

Try to open a database file with IB_SQL. I couldn't.
Restart Firebird service.
Try to open a database file with IB_SQL. I couldn't.
Make a copy of the original Firebird.conf, which has the commented line 
#DatabaseAccess = Full.

In Firebird.conf, uncomment the line DatabaseAccess = Full.
Restart Firebird service.
Try to open a database file with IB_SQL. I could!
Delete the modified Firebird.conf and restore the original one, which 
has the commented line #DatabaseAccess = Full.

Restart Firebird service.
Try to open a database file with IB_SQL. I could!

Conclusion: Now I have the same Firebird.conf as an hour ago, but 
everything is working fine.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in local 
hard disk

*De: *Eduardo 
*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 16:35


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] 


*A: *
*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 
www.csy.co.uk  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]


A: 

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

Re: [firebird-support] Cannot open database file in local hard disk

[Eduardo guse...@gmail.com [firebird-support]]

Yes, I tried indicating the name or IP of the server but it didn't work. 
The only way to open the databases is using an alias.



 Mensaje original 
*Asunto: *Re: [firebird-support] Cannot open database file in local hard 
disk
*De: *Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] 


*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 12:29

Hello,

Did you try some thing like this :

IBODatabase1.Path := your GDB or FDB filename with path...;

IF SERVER_<>'' then // NAME or IP of  the server
   IBODatabase1.Server:=SERVER_ else
IBODatabase1.Server:=PC_NAME; //localhost
if not IBODatabase1.Connected then
   IBODatabase1.Connect;

(using SYSDBA and masterkey.. or user)

Best Regards,
MLCVISTA


Le ‎mardi‎ ‎20‎ ‎février‎ ‎2018‎ ‎16‎:‎09‎:‎33‎ ‎CET, Eduardo 
guse...@gmail.com [firebird-support] 
 a écrit :



Thanks for your suggestion.

The user have total control of the file and the folder. I can modify 
it and even delete it. I tried moving the file to other folders and I 
tried with many FDB files. If I copy the FDB to another computer with 
Firebird, then I can open it without any problem. So the problem seems 
to be related to the computer.


I use Firebird 2.1 since many years ago and it works well. That's why 
I didn´t change it already.



 Mensaje original 
*Asunto: *[firebird-support] Cannot open database file in local hard disk
*De: *Rustam rusta...@ukr.net  
[firebird-support]  

*A: *firebird-support@yahoogroups.com 


*Fecha: *20/02/2018 11:09


1) Check user access rights on DB folder/file and account, under 
which Firebird server is running

2) Why you don't use latest 2.5.8 version of Firebird?




alt 
 
	Libre de virus. www.avast.com 
 



<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Cannot open database file in local hard disk

[Eduardo guse...@gmail.com [firebird-support]]

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



---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Cannot open database file in local hard disk

[Helen Borrie hele...@iinet.net.au [firebird-support]]

>  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] aliases.conf creating the alias
> MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can   open the 
> database.

This is the intended behaviour if you have DatabaseAccess = None
configured in firebird.conf.

HB

Re: [firebird-support] Re: Cannot open database file in local hard disk

[Eduardo guse...@gmail.com [firebird-support]]

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] 


*A: *
*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 
www.csy.co.uk  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]


A: 

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  
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
 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 

Re: [firebird-support] FB 2.5 backed-up DB cannot be restored, msg about Malformed String and "Use -FIX_FSS_DATA option."

[dco...@sympatico.ca [firebird-support]]

Thanks, Dimitry. That's helpful. I think I can fix it by just having my program 
read all of the values in the BLOB SUB_TYPE TEXT field, clear them, then 
re-enter them. It certainly worked for the user we had the problem with.

RE: [firebird-support] Re: Cannot open database file in local hard disk

['Neil Pickles' neil.pick...@csy.co.uk [firebird-support]]

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 
www.csy.co.uk  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] 

 
A: 
 
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   
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
  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 

Re: [firebird-support] Re: Cannot open database file in local hard disk

[Eduardo guse...@gmail.com [firebird-support]]

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] 


*A: *
*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  
*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
 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





Libre de virus. www.avast.com 
 








---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

RE: [firebird-support] Re: Cannot open database file in local hard disk

['Neil Pickles' neil.pick...@csy.co.uk [firebird-support]]

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   
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
  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

 

 

 
 

Libre de virus. www.avast.com
  

Re: [firebird-support] FB 2.5 backed-up DB cannot be restored, msg about Malformed String and "Use -FIX_FSS_DATA option."

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

20.02.2018 16:36, dco...@sympatico.ca [firebird-support] wrote:
> I've Googled a lot about this and that -FIX_FSS_DATA option seems to only 
> really be 
> relevant when restoring DBs from much earlier versions of FB - but this is 
> from the same 
> version!

   Version of engine doesn't matter in this case. ODS does.
   ODS used in 2.0.1 allowed malformed string literals in stored objects and 
data tables, 
ODS for 2.5 prohibit that.
   If you see this error, it means that you'd better migrate database between 
version by 
creation of brand new database from script and then pump data from old 
database. During 
this process you'll encounter errors that you must fix by changing script or 
source database.
   -FIX_* switches must be used very carefully by experienced DBA only. In 
wrong hands 
they will lead to data corruption beyond recovery.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: FB 2.5 backed-up DB cannot be restored, msg about Malformed String and "Use -FIX_FSS_DATA option."

[dco...@sympatico.ca [firebird-support]]

P.S. All columns are UTF8, and that has always been that way since we started 
using FB.

[firebird-support] FB 2.5 backed-up DB cannot be restored, msg about Malformed String and "Use -FIX_FSS_DATA option."

[dco...@sympatico.ca [firebird-support]]

We are in the process of upgrading our app from using FB 2.0.1 to FB 2.5, and 
have a just a few users beta testing that.
 

 I have a DB from a user of that beta version of our software, that has been 
opened successfully in our app using FB 2.5, and that seems to behave 
successfully in the app. It can be backed up successfully with gbak, but if we 
try to restore it with gbak, we get:
 

 gbak: ERROR:Malformed string
gbak: ERROR:Invalid data detected. Use -FIX_FSS_DATA option.
gbak:Exiting before completion due to errors
 

 I've Googled a lot about this and that -FIX_FSS_DATA option seems to only 
really be relevant when restoring DBs from much earlier versions of FB - but 
this is from the same version! Also, I tried adding that option to the gbak 
restore command line, and the result is the same failure.
 

 I did get the impression it could be about data types, perhaps particularly in 
BLOB fields. So I narrowed it down to the BLOB fields in our DB, and it turned 
out that there was one value in in field (type BLOB SUB_TYPE TEXT) in one row 
of the DB, that if I cut the value out in our UI, saved the row, then pasted 
the same value back in again in our UI, and saved the row again, the problem 
goes away - a backup made after that can be restored!
 

 I cannot see anything funny in the value - it's just some text, with a couple 
of embedded CR/LF pairs in it.
 

 This is obviously extremely worrisome, because we are not aware of any 
previous user when we used FB 2.0.1 that ever could not restore a backup. It is 
not good if we are providing software where in some cases, backups users make 
cannot be restored! And we don't even know how to detect such a problem, since 
there didn't appear to be anything wrong with the text in that problem field.
 

 Any thoughts or suggestions? Thanks.
 

Re: [firebird-support] Cannot open database file in local hard disk

[Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]]

 Hello,
Did you try some thing like this :
IBODatabase1.Path := your GDB or FDB filename with path...;
IF SERVER_<>'' then // NAME or IP of  the server
   IBODatabase1.Server:=SERVER_ else
            IBODatabase1.Server:=PC_NAME; //localhost  if not 
IBODatabase1.Connected then
   IBODatabase1.Connect;
(using SYSDBA and masterkey.. or user)
Best Regards,MLCVISTA

Le ‎mardi‎ ‎20‎ ‎février‎ ‎2018‎ ‎16‎:‎09‎:‎33‎ ‎CET, Eduardo 
guse...@gmail.com [firebird-support]  a écrit 
:  
 
     
 

Thanks for your suggestion.
 
 The user have total control of the file and the folder. I can modify it and 
even delete it. I tried moving the file to other folders and I tried with many 
FDB files. If I copy the FDB to another computer with Firebird, then I can open 
it without any problem. So the problem seems to be related to the computer.
 
 I use Firebird 2.1 since many years ago and it works well. That's why I didn´t 
change it already.
 
 
  Mensaje original 
 Asunto: [firebird-support] Cannot open database file in local hard disk
 De: Rustam rusta...@ukr.net [firebird-support] 

 A: firebird-support@yahoogroups.com
 Fecha: 20/02/2018 11:09
  
    
1) Check user access rights on DB folder/file and account, under which Firebird 
server is running
 2) Why you don't use latest 2.5.8 version of Firebird?
 
  
 
 
 
|  | Libre de virus. www.avast.com  |

   #yiv3964543233 #yiv3964543233 -- #yiv3964543233ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3964543233 
#yiv3964543233ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3964543233 
#yiv3964543233ygrp-mkp #yiv3964543233hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3964543233 #yiv3964543233ygrp-mkp #yiv3964543233ads 
{margin-bottom:10px;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad 
{padding:0 0;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad p 
{margin:0;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad a 
{color:#ff;text-decoration:none;}#yiv3964543233 #yiv3964543233ygrp-sponsor 
#yiv3964543233ygrp-lc {font-family:Arial;}#yiv3964543233 
#yiv3964543233ygrp-sponsor #yiv3964543233ygrp-lc #yiv3964543233hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3964543233 
#yiv3964543233ygrp-sponsor #yiv3964543233ygrp-lc .yiv3964543233ad 
{margin-bottom:10px;padding:0 0;}#yiv3964543233 #yiv3964543233actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3964543233 
#yiv3964543233activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3964543233
 #yiv3964543233activity span {font-weight:700;}#yiv3964543233 
#yiv3964543233activity span:first-child 
{text-transform:uppercase;}#yiv3964543233 #yiv3964543233activity span a 
{color:#5085b6;text-decoration:none;}#yiv3964543233 #yiv3964543233activity span 
span {color:#ff7900;}#yiv3964543233 #yiv3964543233activity span 
.yiv3964543233underline {text-decoration:underline;}#yiv3964543233 
.yiv3964543233attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3964543233 .yiv3964543233attach div a 
{text-decoration:none;}#yiv3964543233 .yiv3964543233attach img 
{border:none;padding-right:5px;}#yiv3964543233 .yiv3964543233attach label 
{display:block;margin-bottom:5px;}#yiv3964543233 .yiv3964543233attach label a 
{text-decoration:none;}#yiv3964543233 blockquote {margin:0 0 0 
4px;}#yiv3964543233 .yiv3964543233bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3964543233 
.yiv3964543233bold a {text-decoration:none;}#yiv3964543233 dd.yiv3964543233last 
p a {font-family:Verdana;font-weight:700;}#yiv3964543233 dd.yiv3964543233last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3964543233 
dd.yiv3964543233last p span.yiv3964543233yshortcuts 
{margin-right:0;}#yiv3964543233 div.yiv3964543233attach-table div div a 
{text-decoration:none;}#yiv3964543233 div.yiv3964543233attach-table 
{width:400px;}#yiv3964543233 div.yiv3964543233file-title a, #yiv3964543233 
div.yiv3964543233file-title a:active, #yiv3964543233 
div.yiv3964543233file-title a:hover, #yiv3964543233 div.yiv3964543233file-title 
a:visited {text-decoration:none;}#yiv3964543233 div.yiv3964543233photo-title a, 
#yiv3964543233 div.yiv3964543233photo-title a:active, #yiv3964543233 
div.yiv3964543233photo-title a:hover, #yiv3964543233 
div.yiv3964543233photo-title a:visited {text-decoration:none;}#yiv3964543233 
div#yiv3964543233ygrp-mlmsg #yiv3964543233ygrp-msg p a 
span.yiv3964543233yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3964543233 
.yiv3964543233green {color:#628c2a;}#yiv3964543233 .yiv3964543233MsoNormal 
{margin:0 0 0 0;}#yiv3964543233 o {font-size:0;}#yiv3964543233 
#yiv3964543233photos div {float:left;width:72px;}#yiv3964543233 
#yiv3964543233photos div div {border:1px solid 

Re: [firebird-support] Cannot open database file in local hard disk

[Eduardo guse...@gmail.com [firebird-support]]

Thanks for your suggestion.

The user have total control of the file and the folder. I can modify it 
and even delete it. I tried moving the file to other folders and I tried 
with many FDB files. If I copy the FDB to another computer with 
Firebird, then I can open it without any problem. So the problem seems 
to be related to the computer.


I use Firebird 2.1 since many years ago and it works well. That's why I 
didn´t change it already.



 Mensaje original 
*Asunto: *[firebird-support] Cannot open database file in local hard disk
*De: *Rustam rusta...@ukr.net [firebird-support] 


*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 11:09


1) Check user access rights on DB folder/file and account, under which 
Firebird server is running

2) Why you don't use latest 2.5.8 version of Firebird?






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Cannot open database file in local hard disk

[Rustam rusta...@ukr.net [firebird-support]]

1) Check user access rights on DB folder/file and account, under which Firebird 
server is running
2) Why you don't use latest 2.5.8 version of Firebird?

[firebird-support] Re: Cannot open database file in local hard disk

[Eduardo guse...@gmail.com [firebird-support]]

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 
*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 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





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Cannot open database file in local hard disk

[Eduardo guse...@gmail.com [firebird-support]]

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



---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus