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

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

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

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

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

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

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

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

[firebird-support] Re: FB3 Embedded on Android

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

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

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

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

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

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

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

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

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] Cannot open database file in local hard disk

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

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

> 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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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   

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

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

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

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

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

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

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