Subject Re: [firebird-support] FB3 Embedded Firedac Error
Author Elton Fadel
>This is quite interesting, if the service is stopped and no Firebird server running, then how can you access the database, it might be that you >already correctly setup the embedded server and the application load the embedded server


IB-Expert and Delphi still running with all databases.
Probably the shutdown function is missing on FB 3, or the default engine is Embedded case it is off.
Em terça-feira, 3 de setembro de 2019 09:23:59 BRT, Iwan Cahyadi Sugeng iwan.c.sugeng@... [firebird-support] <firebird-support@yahoogroups.com> escreveu:


 

See my replies below

On Tue, Sep 3, 2019 at 1:13 PM Elton Fadel galdarius3@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
 


Thanks, Mark! It worked!

I also notice something very interesting during my tests:

1. No matter if you use Firebird if a Service or Application, even without installing the guardian:
Stop the Service or do Shutdown of the Application on tray icon has zero effect!
It stays working normally on Delphi, IB-Expert and in your Applications.
You really need to completely uninstall Firebird on Windows Settings.


This is quite interesting, if the service is stopped and no Firebird server running, then how can you access the database, it might be that you already correctly setup the embedded server and the application load the embedded server
 
2. Delphi (Firedac at least) in Design Time uses BY DEFAULT Firebird installed on your machine, whatever if it is stoped or running (explained above).
On Runtime it will use the settings that you have, to use Embedded. So, stay alert: You can't use Embedded in Design Time if you have Firebird installed on or machine. You need a complete uninstall to do it.

Anyway, it works!
Thanks again.
Em terça-feira, 3 de setembro de 2019 02:00:25 BRT, Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> escreveu:


 

On 3-9-2019 05:38, Elton Fadel galdarius3@...
[firebird-support] wrote:
> /5. This error occurs when you are using a 'fbclient.dll' that doesn't have
> access to 'plugins/engine12.dll'./
> /5b. This error can occur if your application is 32
> bit and the Firebird files are 64 bit (or vice versa), then at runtime
> it could loads a different fbclient.dll./
>
> *==About my installation and Fbclient.dll==*
> *\Windows executable installer/*
> https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054_0_Win32.
> exe:
> C:\Program Files (x86)\Firebird\Firebird_3_0\fbclient.dll
>
> *\Zip kit for manual/custom installs/*
> https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0_Win32.zip:
> D:\Desktop\Server\EDBMS\fbclient.dll
>
> *Both are the same file: 3.0.4.33054 and both with 1.369.088 bytes.*

> /6. You could use sysinternal procmon to check which files actually get
> loaded and used./
>
> *Apparently, there's no need and I even don't know how to do it.*

Why is there "no need"? If you want to solve your problem, it is good to
know which libraries get loaded by your application.

I have only ever seen this error when plugins\engine12.dll is either not
present in the folder with fbclient.dll, or with different bitness
between application and client, or client and engine12.dll.

> /7. In firebird.conf, what is the setting for Providers?/
>
> *#Providers = Remote,Engine12,Loopback
> *But i also tried only:*
> *
> *#Providers = Engine12*

When it is prefixed with a # it is a comment, if you want to try with
Providers = Engine12, then you need to remove the #.

Mark
--
Mark Rotteveel