fbembed.dll crashed Delphi

Hi,

when I change the property from Active:=True to Active:=False
in the TSQLConnection ( dbExpress Component in Delphi 7 )
Delphi crash.
It's maybe a problem on unload the fbembed.dll by closing the (last/only) connection to the embedded Firebird-Db?!

It happens at the following configuration:

OS: NT4
IDE: Delphi 7

Form definition
===========

object Form1: TForm1
Left = 266
Top = 122
Width = 367
Height = 252
Caption = 'Form1'
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -11
Font.Name = 'MS Sans Serif'
Font.Style = []
OldCreateOrder = False
PixelsPerInch = 96
TextHeight = 13
object SQLConnection1: TSQLConnection
ConnectionName = 'IBConnection'
DriverName = 'Interbase'
GetDriverFunc = 'getSQLDriverINTERBASE'
LibraryName = 'dbexpint.dll'
LoginPrompt = False
Params.Strings = (
'DriverName=Interbase'
'Database=D:\Sources\Delphi\ThdTest\data\default.fdb'
'RoleName=RoleName'
'User_Name=sysdba'
'Password=masterkey'
'ServerCharSet='
'SQLDialect=3'
'ErrorResourceFile='
'LocaleCode=0000'
'BlobSize=-1'
'CommitRetain=False'
'WaitOnLocks=True'
'Interbase TransIsolation=ReadCommited'
'Trim Char=False')
VendorLib = 'fbembed.dll'
Left = 40
Top = 24
end
end

Hmmm... How about using the Firebird dbExpress driver at www.upscene.com ?

Thanks a lot for your quick reply.
The Firebird dbExpress driver from URL do the job perfect!
The only disadvantage ... it's not free ;o(

For the moment I have found an other/dirthy solution ... for the runtime

var
hDLL: THandle;

initialization

//=========================================
// Load the "fbembedi.dll" before "TSQLConnection" can
// do it!
//=========================================
hDLL := LoadLibrary('fbembed.dll');

finalization

//=========================================
// All "TSQLConnection"-Connections to an embedded
// Firebird-DB should be disconnected at this point!
//=========================================
if hDLL <> INVALID_HANDLE_VALUE
then FreeLibrary(hDLL);

Well, that's the problem. You're using Firebird, with an InterBase dbExpress driver (made by Borland). You cannot expect the InterBase driver to stay compatible with Firebird - they simply won't do that.

If you like programming around problems and thinking of hacks every now and then instead of paying a few $$, then go ahead