[firebird-support] Re: Why won't Firebird restore backups from a network drive?

2019-11-13 Thread dco...@sympatico.ca [firebird-support]
Thank you, that is the correct answer. When I tried with embedded Firebird, that doesn't use the services manager, it works fine, with either way of accessing the network drive (UNC path or mapped drive letter). Feeling a bit dumb. :)

Re: [firebird-support] Why won't Firebird restore backups from a network drive?

2019-11-13 Thread dco...@sympatico.ca [firebird-support]
We're actually already doing the backups and restores with the Services API.

[firebird-support] Why won't Firebird restore backups from a network drive?

2019-11-13 Thread dco...@sympatico.ca [firebird-support]
Whether I used a mapped drive letter, or a UNC path, if I try to restore a backup from a network drive it fails, with a message like "Cannot open file". I fully understand why Firebird won't open a database file on a network drive, but I'm trying to do the restore to a DB on a local drive.

[firebird-support] UDF written in Visual Studio C giving "malformed string" on accents in characters

2019-09-20 Thread dco...@sympatico.ca [firebird-support]
I have a UDF that needs to takes a couple of CSTRING(255) arguments and returns CSTRING(8000), but it needs to be able to handle accented characters like in French.. The UDF is written in C and compiled in MS Visual Studio, using the normal "char" character type. I tried changing that to

[firebird-support] gfix gives "data page error" but errorlevel 0

2019-01-23 Thread dco...@sympatico.ca [firebird-support]
I have a database that is having problems. (Trying to back it up gives errors.) When I run gfix -v -n -full on it, I get: Summary of validation errors Number of data page errors : 1 But the errorlevel return from gfix is 0, indicating no error. I have actually

[firebird-support] Re: Code signed version of Firebird SQL executables?

2018-10-28 Thread dco...@sympatico.ca [firebird-support]
I'm actually doing that for making backups, Dimitry. Not sure I knew it could be used for restoring them. You think that would work around the problem? Also, we also use gfix for database validation, and have the same problem with where its log file goes. Can that also be done through the

[firebird-support] Can't connect to Linux FB 2.5 remotely

2018-03-29 Thread dco...@sympatico.ca [firebird-support]
We have set up a FB 2.5 on a Linux server. We can access it locally from the server, but when we try to access it from any other computer on our local network (from which we can successfully ping the server), we get: Statement failed, SQLSTATE = 08006 Unable to complete network request to

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

2018-02-20 Thread 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.

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

2018-02-20 Thread 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."

2018-02-20 Thread 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.