TIBCBackupService with fbclient3 and umlauts

[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

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

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

[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

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

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

[arndb]

Yes, you are right: fbClient 3.0.0 fix the issue with Firebird 3, but not with Firebird 2.5 .

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