Page 1 of 1

TIBCBackupService with fbclient3 and umlauts

Posted: Mon 15 Jan 2018 15:33
by arndb
Hi,

I have a small problem with german characters (umlauts) in path or database name using "TIBCBackupService".

Part of the error message:

... 'I/O error during "CreateFile (open)" operation for file "C:\FB30\DATABASE_öüä\DB.F30DB"
Error while trying to open file

this happens with firebird 25 and firebird 30 but only with the fbclient 3.
Same source with firebird 25 and fbclient 2.5 works!

Without the umlauts everthing works fine.


We are using IBDAC 6.1 // Delphi 2007 !! // Firebird 2.5 and Firebird 3.0 // fbclient 3

Re: TIBCBackupService with fbclient3 and umlauts

Posted: Mon 15 Jan 2018 15:46
by ViktorV
Unfortunately we could not reproduce the issue on the latest IBDAC 6.1.4 version.
Please check whether the problem occurs on the latest version IBDAC 6.1.4 and inform us about the result. It it is, please compose a full sample demonstrating the described behavior and send it to us via e-support form: https://www.devart.com/company/contactform.html, including scripts for creating database objects.

Re: TIBCBackupService with fbclient3 and umlauts

Posted: Mon 15 Jan 2018 16:48
by arndb
Hi ViktorV,

we are using IBDAC 6.1.4 in Delphi 2007

This test is easy: I´m using EMPLOYEE from ...\examples\empbuild\EMPLOYEE.FDB
Change the fbclient and you can see the problem.

With server Firebird 2.5 and Firebird 3.0 (fbclient 3 only) I have the same problem.
With fbclient 2.5 its working, with 3.02 (latest version [32bit] not.

// CLIENT_FILE = 'c:\test\client25\fbclient.dll'; //2.5 -> everything works (in FB2.5)
CLIENT_FILE = 'c:\test\client30\fbclient.dll '; //3.02 -> my problem ;-) (in FB2.5.
DATABASE_FILE = 'c:\test\Database_öäü\EMPLOYEE.FDB'; // <- Umlauts in Database path
BACKUP_FILE = 'c:\test\Database_öäü\EMPLOYEE.FBK'; // <- Umlauts in Database path

backup:= TIBCBackupService.Create(nil);
backup.LoginPrompt := false;
backup.Verbose:= True;
backup.ClientLibrary := CLIENT_FILE;
backup.Username := 'SYSDBA';
backup.Password := '***';
backup.Server := SERVER;
backup.database := DATABASE_FILE;
backup.backupfile.text := BACKUP_FILE;
backup.Attach;
backup.ServiceStart;
backup.Detach;

Re: TIBCBackupService with fbclient3 and umlauts

Posted: Tue 16 Jan 2018 12:50
by ViktorV
This behavior is not related to IBDAC functionality, but to work specificity of the Firebird 3 client library of 3.x.x version.
We will consider the possibility of circumventing this limitation of the Firebird 3 client library in the next release of IBDAC.
Note, currently, to solve the issue, you can use the Firebird 3 client library of version 3.0.0

Re: TIBCBackupService with fbclient3 and umlauts

Posted: Wed 17 Jan 2018 09:36
by arndb
okay, thank you for testing. I hope you consider circumventing ...

I also tried fbClient 3.0.0.32483 but this doesn´t solve the problem, same error.

Re: TIBCBackupService with fbclient3 and umlauts

Posted: Wed 17 Jan 2018 11:46
by ViktorV
As we have written earlier, using the client library 3.0.0.32483 should fix the issue only when working with Firebird 3 server.

Re: TIBCBackupService with fbclient3 and umlauts

Posted: Wed 17 Jan 2018 14:16
by arndb
Yes, you are right: fbClient 3.0.0 fix the issue with Firebird 3, but not with Firebird 2.5 .

Re: TIBCBackupService with fbclient3 and umlauts

Posted: Thu 18 Jan 2018 11:34
by ViktorV
The new IBDAC 6.1.5 with a fix for this issue is already available for download now.
In the new version, you won't be able to work with the client library 3.0.0.32483 with Firebird 2.5 either, due to the behavior of this version of the Firebird 3 client library, and we cannot affect it. But, in the new version, you can work with Firebird 2.5 using the older versions of the client library Firebird 3.