fbintl.dll never get unloaded in Firebird 2.X Embedded after invoke isc_dsql_execute_immediate for CREATE DATABASE [CORE2186]

[firebird-automations]

Submitted by: Chau Chee Yang (cheeyang)

In Firebird 2.0 and 2.1 Embedded, I notice fbintl.dll will be loaded once I executed isc_dsql_execute_immediate for "CREATE DATABASE". However, the fbintl.dll never get unloaded after I free fbembed.dll.

This cause problems when I use Firebird 2.0 embedded and Firebird 2.1 embedded engine in same application where the fbintl.dll for both 2.0 and 2.1 is not compatible.

To solve the problem temporary, I unload the fbintl.dll library manually:

const FLibrary = 'fbembed.dll'

var s: string;
h: THandle;
begin
...
s := ExtractFilePath(FLibrary) + 'intl\fbintl.dll';
h := GetModuleHandle(PChar(s));
if h <> 0 then
FreeLibrary(h);
end;

Commits: ad24045

[firebird-automations]

Commented by: Sean Leyne (seanleyne)

I don't understand why a *single* application needs to use 2 embedded engines (of different versions) at the same time.

Please explain.

[firebird-automations]

Commented by: Chau Chee Yang (cheeyang)

My application works with both ODS version 10.X and 11.X database, thus I may switch the firebird engine to access database depends on the ODS version. The reason why not upgraded to latest 11.1 version is I have other legacy apps that can't work with 11.X database yet.

Regardless of the above issue, I think it is a good habit to unload fbintl.dll when it is no longer needed.

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Cannot be tested