Re: [firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 30-4-2019 23:51, Robert martin r...@chreos.com [firebird-support] wrote:
> I haven't been following the thread, so this may be totally of track 
> but, Embedded only supports one connection.  If you try to connect a 
> second instance you get the database unavailable error message you are 
> seeing.  Is it simply that you have something else (your app or a DB 
> tool?) connected to the DB already when you are trying from the IDE?

That is not correct, embedded supports multiple connections from the 
same process. And with Firebird 3 if you use embedded with in its 
firebird.conf setting ServerMode = Classic or SuperClassic, you can 
connect to the same database from multiple processes (you just need to 
make sure that all processes share the same lock files, although that 
should happen by default).

Mark
-- 
Mark Rotteveel

Re: [firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

[Robert martin r...@chreos.com [firebird-support]]

Hi Chris

I haven't been following the thread, so this may be totally of track 
but, Embedded only supports one connection.  If you try to connect a 
second instance you get the database unavailable error message you are 
seeing.  Is it simply that you have something else (your app or a DB 
tool?) connected to the DB already when you are trying from the IDE?


Cheers
Rob

On 30/04/2019 1:41 PM, 'Chris LeFebvre' lefebv...@comcast.net 
[firebird-support] wrote:


Eric:

Thanks for your help, the example went a long way to getting my 
problem fixed. These are the steps I took and the results:


I saved your programs files to a unique directory, created a new empty 
project and added your .pas file to the project; added the 64bit 
platform to the project and made it active, copied the test employees 
database to the Debug directory along with the files from the Firebird 
x64 kit and set the text of the TEdit to the full path to the 
database. I was able to connect both in designtime and runtime. I 
copied my database to the Debug directory and changed the text of the 
Tedit to be my database and again I was able to connect both in 
designtime and runtime.


I examined the project that I was w orking on and really had a hard 
time pining down what exactly was the difference because everything 
seemed to be the same but when I added your code (customized to my 
component names and details):


  FDConnection1.Params.Clear;

  FDConnection1.DriverName := 'FB';

  FDConnection1.Params.Database := Edit1.Text;

  //FDConnection1.Params.UserName := 'SYSDBA';

  //FDConnection1.Params.Password := 'masterkey';

  FDPhysFBDriverLink1.VendorLib := 'fbclient.dll';

  FDPhysFBDriverLink1.Embedded := True;

  FDConnection1.Connected := True;

  MessageDlg('Connection OK !', mtInformation, [mbOK], 0);

& nbsp;

I got my program to work during runtime but I still can’t get it to 
connect during designtime, even though each of the parameter options 
appear to be exactly what your code is setting them to I still get 
“Unavailable database” when I check off Connected in the IDE.


I’ll have to work on this a little more but there must be some 
parameter that is set incorrectly in designtime that is cleared during 
runtime by the FDConnection1.Params.Clear statement, at least that’s 
my current theory. If I

[firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

['Chris LeFebvre' lefebv...@comcast.net [firebird-support]]

Eric:

 

Thanks for your help, the example went a long way to getting my problem
fixed. These are the steps I took and the results:

 

I saved your programs files to a unique directory, created a new empty
project and added your .pas file to the project; added the 64bit platform to
the project and made it active, copied the test employees database to the
Debug directory along with the files from the Firebird x64 kit and set the
text of the TEdit to the full path to the database. I was able to connect
both in designtime and runtime. I copied my database to the Debug directory
and changed the text of the Tedit to be my database and again I was able to
connect both in designtime and runtime.

 

I examined the project that I was working on and really had a hard time
pining down what exactly was the difference because everything seemed to be
the same but when I added your code (customized to my component names and
details):

 

  FDConnection1.Params.Clear;

  FDConnection1.DriverName := 'FB';

  FDConnection1.Params.Database := Edit1.Text;

  //FDConnection1.Params.UserName := 'SYSDBA';

  //FDConnection1.Params.Password := 'masterkey';

  FDPhysFBDriverLink1.VendorLib := 'fbclient.dll';

  FDPhysFBDriverLink1.Embedded := True;

  FDConnection1.Connected := True;

  MessageDlg('Connection OK !', mtInformation, [mbOK], 0);

 

I got my program to work during runtime but I still can't get it to connect
during designtime, even though each of the parameter options appear to be
exactly what your code is setting them to I still get "Unavailable database"
when I check off Connected in the IDE.

 

I'll have to work on this a little more but there must be some parameter
that is set incorrectly in designtime that is cleared during runtime by the
FDConnection1.Params.Clear statement, at least that's my current theory. If
I find out exactly what the problem is I'll report back.

 

[firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

[Eric Guéguiniat eric.gueguin...@gmail.com [firebird-support]]

Hi,

I made a demo just to connect an fb embedded DB
Compile it and run it where you have intalled firebird files (change file
path)

If you can't connect DB with this, I will give you the exe file

And if it works only with my exe,, then the problem comes from DXE10.3.1

Eric


[Non-text portions of this message have been removed]

[firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

['Chris LeFebvre' lefebv...@comcast.net [firebird-support]]

Helen Borrie:

 

I can't connect within the IDE or outside the IDE with the IDE closed and I
don't have the database file open in any management software and I've
verified that no other software has the database open / locked using Process
Explorer. 

 

Regarding bitness, still not sure because I've read conflicting information
but in other applications I develop where I use regular Firebird server on
my Windows Server 2016 computer and develop 64bit application on my
development computer I have the 64bit fbclient.dll in my application
directory and I am able to check off Connected in the TFDConnection and be
connected to the server. So it's hard to know when so many different people
are saying different things.

 

Re "I think it's a mistake to try and do a custom Firebird install for your
early testing. Just unzip the whole thing and then go back later and get rid
of the pieces you don't need" again so many people saying so many things;
I've copied the contents of the unzipped Firebird x64 kit to my application
directory (along with any sub-directories) and when that didn't work I tried
copying some of the files from the plugins directory to the application
directory just to see if that would work and I still can't get a connection.

 

  eric.gueguin...@gmail.com:

 

"FDConnection.Params.Database" = the full path to the fdb file and it's not
blank.

 

Karol Bieniaszewski

 

As I mentioned above, I copied the contents of the Firebird x64 kit to my
application directory including any subdirectories but when I still couldn't
get a connection I tried copying some of the files from the plugins
directory to my application directory just to see if that would work.

Re: [firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

[Helen Borrie hele...@tpg.com.au [firebird-support]]

Chris LeFebvre wrote:

> One thing, my application is 64bit and I do have the 64bit
> fbclient.dll in the Debug / application so can you connect to an
> embedded database at design time by checking the Connected property
> of the TFDConnection component? I remember reading somewhere that
> during design time that since the IDE is 32bit that in certain
> instances there may be a bitness problem between design time and run
> time? But regardless of if it’s designed time or run time I still get 
> “Database unavailable”?

1.  Only one application can be connected to a particular database with an
embedded connection.  So, if your Delphi project is still open
when you try to run your executable, you will get "Database
unavailable" in your executable.  (If you are running a database
tool such as isql or FlameRobin that's connected to that database,
the problem is the same).

2.  Those guys on the idera forum have got it wrong.  In Firebird 3,
(fbclient.dll + engine12.dll) are equivalent to fbembed.dll in the
older Fb versions.  You DO NOT rename anything to fbembed.dll.

3.  The VendorLib is fbclient.dll in both environments.  The
bitness-appropriate DLL should be in the application directory, so if
the Delphi IDE really is still 32-bit then you need the 32-bit DLL at
design time, as fbclient.dll is where the API is implemented.

OTOH, if you compiled you executable as 64-bit, then it is is the
64-bit fbclient.dll you want in the application directory of your
executable.  Engine12.dll (in the \plugins subdir beneath your
executable) is the Firebird database engine, through which your client
will connect to databases.  It can be 32-bit or 64-bit on a 64-bit box
- your choice.

4.  I think it's a mistake to try and do a custom Firebird install for
your early testing.  Just unzip the whole thing and then go back later
and get rid of the pieces you don't need.

Helen


---
This email has been checked for viruses by AVG.
https://www.avg.com







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

[eric.gueguin...@gmail.com [firebird-support]]

I compiled my program in WIN64 and connected DB 
..\examples\empbuild\EMPLOYEE.FDB with FB3 embedded x64, but I used Delphi 
XE10.2.3 ... 

 To have the exactly your error  “[FireDAC]{Phys][FB]unavailable database” I 
must set : FDConnection.Params.Database := '';
 

 Have you sure that property Database is not empty ?
 

 I you want, make a small demo with only a connection to a database and I will 
check if it works with DXE10.2.3
 

 Eric

Re: [firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

If i see good on my phone you have engine12.dll in the same dir as exe but it 
should be in plugins. Are you sure that did you copied whole structure from zip 
kit?Regards,Karol Bieniaszewski
null

[firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

['Chris LeFebvre' lefebv...@comcast.net [firebird-support]]

Liviuslivius:

 

As per Frank Schlottmann's response: "Your application directory should
contain the following Firebird 

directories

lib

intl

plugins

 

and the following files:

fbclient.dll

firebird.msg

ibutil.dll

icudt63.dll

icudt63l.dat

icuin63.dll

icuuc63.dll"

 

But as he mentioned he's using Firebird 4 beta and for example icudt63.dll
is icudt53.dll in Firebird 3; just in case I was missing something I copied
the contents of the Firebird zip kit to my applications Debug directory
including any subdirectories located in the Firebird directory; I did delete
Firebird.exe since the documentation says it's not necessary for embedded.
Here's a directory listing of my Debug directory minus any Delphi dcu files:

Volume in drive I is Data

Volume Serial Number is A327-5FF0

 

Directory of I:\Delphi\Test-Embedded\Win64\Debug

 

04/24/2019  11:47 AM  .

04/24/2019  11:47 AM  ..

05/07/2017  11:45 PM   170 Attributes.txt

05/07/2017  11:45 PM   170 Categorys.txt

01/28/2019  07:57 PM 2,293,760 ComTestEm.FDB

10/03/2018  02:46 PM 7,053,824 engine12.dll

04/23/2019  08:01 PM11,917 EntVarInfoP.dcu

03/27/2015  11:40 AM   876,032 fbclient.dll

10/03/2018  02:47 PM   285,184 fbguard.exe

10/03/2018  02:46 PM   314,880 fbsvcmgr.exe

10/03/2018  02:41 PM   634,880 fbtrace.dll

10/03/2018  02:47 PM   307,712 fbtracemgr.exe

10/03/2018  02:47 PM   303,616 fb_lock_print.exe

04/23/2019  11:36 PM32,897 firebird.conf

10/03/2018  02:46 PM   149,648 firebird.msg

10/03/2018  02:47 PM   700,416 gbak.exe

10/03/2018  02:47 PM   327,168 gfix.exe

10/03/2018  02:45 PM   878,592 gpre.exe

10/03/2018  02:47 PM   352,768 gsec.exe

10/03/2018  02:47 PM   270,848 gsplit.exe

10/03/2018  02:47 PM   332,288 gstat.exe

10/03/2018  02:40 PM 8,192 ib_util.dll

02/20/2014  05:09 AM 3,072 icudt52.dll

01/12/2016  09:31 PM 5,616,608 icudt52l.dat

10/05/2013  12:22 AM 1,707,520 icuin52.dll

10/05/2013  12:20 AM 1,293,824 icuuc52.dll

07/09/2003  01:59 AM26,519 IDPLicense.txt

11/12/2015  10:19 AM   410 install_service.bat

10/03/2018  02:46 PM19,456 instclient.exe

10/03/2018  02:47 PM12,288 instreg.exe

10/03/2018  02:46 PM   272,384 instsvc.exe

04/23/2019  05:11 PM  intl

07/09/2003  01:59 AM24,405 IPLicense.txt

10/03/2018  02:46 PM   641,536 isql.exe

04/23/2019  05:11 PM  lib

03/18/2010  11:36 AM   607,568 msvcp100.dll

03/18/2010  11:36 AM   827,728 msvcr100.dll

10/03/2018  02:46 PM   329,216 nbackup.exe

04/23/2019  11:37 PM  plugins

10/03/2018  02:46 PM   566,272 qli.exe

10/03/2018  03:17 PM 1,991 Readme.txt

10/03/2018  02:46 PM 1,605,632 security3.fdb

02/11/2019  10:10 PM46 server.ini

06/01/2018  11:00 PM22 Thumbs.ini

10/03/2018  02:47 PM   386,048 udr_engine.dll

11/10/2015  12:08 PM   273 uninstall_service.bat

12/01/2014  10:44 AM77,824 zlib1.dll

 

My application is set to be compiled as 64bit and I'm using the x64 Firebird
kit; you mention "Firebird files should be in the same dir as your exe with
folder structure e.g /providers and /udf if you use" I can't find any
reference to a "providers" or "udf" directory, they're not in the Firebird
kit and the https://www.ibphoenix.com/files/Embedded_fb3.pdf document
doesn't mention them. Also as someone else suggested, I tried running the
application directly outside of the IDE and I still the error
"[FireDAC]{Phys][FB]unavailable database".

Re: [firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

[Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]]

Am 24.04.19 um 15:52 schrieb 'Chris LeFebvre' lefebv...@comcast.net 
[firebird-support]:



I’ve gone over the three responses by liviuslivius, Dimitry Sibiryakov 
and Frank_Schlottmann-G=c3=b6dde.


I must have misunderstood something in the documentation so I switched 
the VendorLib in the TFDPhysFBDriverLink back to fbclient.dll.


Liviuslivius: In FDConnection1 settings are the same as what you 
describe, I checked and by default the providers line was commented 
out in firebird.conf and I edited it to only be ”Providers = Engine12”


Frank_Schlottmann: I also followed your directions but the version 3 
dll’s are the same name but they have 52 instead of 62.


One thing, my application is 64bit and I do have the 64bit 
fbclient.dll in the Debug / application so can you connect to an 
embedded database at design time by checking the Connected property of 
the TFDConnection component? I remember reading somewhere that during 
design time that since the IDE is 32bit that in certain instances 
there may be a bitness problem between design time and run time? But 
regardless of if it’s designed time or run time I still get “Database 
unavailable”?




You could try to use sth. like:
[FB40]
; FB40 virtual driver will use specified Firebird client library
BaseDriverID=FB
VendorLibWin32=C:\Program Files\Firebird\Firebird_4_0\WOW64\fbclient.dll
VendorLibWin64=C:\Program Files\Firebird\Firebird_4_0\fbclient.dll

in your fddrivers.ini.

The ide needs a 32-bit-Version.

http://docwiki.embarcadero.com/RADStudio/Rio/en/Configuring_Drivers_(FireDAC)



mit freundlichen Grüßen
Frank Schlottmann-Gödde

Re: [firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hiare you sure that you have all files in the same dir as your executable? Also 
are you sure that database is not opened in e.g. IDE in design time or some 
tool? Try rename its file and run executable from directory not from IDE.And 
put whole error message here.Regards,Karol Bieniaszewski
null

[firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

['Chris LeFebvre' lefebv...@comcast.net [firebird-support]]

I've gone over the three responses by  liviuslivius, Dimitry Sibiryakov and
Frank_Schlottmann-G=c3=b6dde.

 

I must have misunderstood something in the documentation so I switched the
VendorLib in the TFDPhysFBDriverLink back to fbclient.dll.

 

Liviuslivius: In FDConnection1 settings are the same as what you describe, I
checked and by default the providers line was commented out in firebird.conf
and I edited it to only be "Providers = Engine12"

 

Frank_Schlottmann: I also followed your directions but the version 3 dll's
are the same name but they have 52 instead of 62.

 

One thing, my application is 64bit and I do have the 64bit fbclient.dll in
the Debug / application so can you connect to an embedded database at design
time by checking the Connected property of the TFDConnection component? I
remember reading somewhere that during design time that since the IDE is
32bit that in certain instances there may be a bitness problem between
design time and run time? But regardless of if it's designed time or run
time I still get "Database unavailable"?