[firebird-support] FB3 Embedded Firedac Error
Error: Failed to connect to DBMS ! [FireDAC][Phys][FB]Unable to complete network request to host "xnet://Global\FIREBIRD". Yes, I know I need only theses files for embedded: intl lib plugins > engine12.dll udf databases.conf fbclient.dll firebird.conf firebird.msg gbak.exe gfix.exe gstat.exe ib_util.dll icudt52.dll icudt52l.dat icuin52.dll icuuc52.dll isql.exe msvcp100.dll msvcr100.dll nbackup.exe zlib1.dll I just shut down the Firebird service and tried to connect it by setting FDPhysFBDriverLink1 to Embedded := True and the VendorLib to the right fbclient.dll. There is nothing about it on the internet. Only people asking about it on forums with no replay. There is a huge lack of material about it nowadays. This group is my last hope.
Re: [firebird-support] FB3 Embedded Firedac Error
On 2-9-2019 04:59, Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > Error: > *Failed to connect to DBMS ! > [FireDAC][Phys][FB]Unable to complete network request to host > "xnet://Global\FIREBIRD".* This error occurs when you are using a `fbclient.dll` that doesn't have access to `plugins/engine12.dll`. > Yes, I know I need only theses files for embedded: > > /intl > lib > plugins > engine12.dll > udf > databases.conf > fbclient.dll > firebird.conf > firebird.msg > gbak.exe > gfix.exe > gstat.exe< br>ib_util.dll > icudt52.dll > icudt52l.dat > icuin52.dll > icuuc52.dll > isql.exe > msvcp100.dll > msvcr100.dll > nbackup.exe > / > /zlib1.dll/ > I just shut down the Firebird service and tried to connect it by setting > *FDPhysFBDriverLink1* to *Embedded := True* and the *VendorLib *to the > right *fbclient.dll*/*.* Is your application 32 bit or 64 bit? Are the Firebird files you are using 32 bit or 64 bit? 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. See https://stackoverflow.com/q/53817952/466862 You could use sysinternal procmon to check which files actually get loaded and used. In firebird.conf, what is the setting for Providers? -- Mark Rotteveel
Re: [firebird-support] FB3 Embedded Firedac Error
Hi1. Is it Windows application?2. Is it 32 bit application or 64 bit?3. Which version of Delphi?4. How your Firedac connection params looks like?Regards,Karol Bieniaszewski null
Re: [firebird-support] FB3 Embedded Firedac Error
Thank you all for the replies. All your questions are above together: 1. Is it Windows application? Yes. 2. Is it 32 bit application or 64 bit? 32 . 3. Which version of Delphi? Last one, 10.3.2 Rio. 4. How your Firedac connection params looks like? Database=D:\Desktop\Server\DB.FDB CharacterSet=UTF8 User_Name=sysdba Password=masterkey DriverID=FB (Embedded property of FDPhysFBDriverLink is set to True) 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. 7. In firebird.conf, what is the setting for Providers? #Providers = Remote,Engine12,Loopback But i also tried only: #Providers = Engine12 I also need to say that I did it following steps on ibphoenix tutorial:https://www.ibphoenix.com/files/Embedded_fb3.pdf Em segunda-feira, 2 de setembro de 2019 03:56:03 BRT, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] escreveu: Hi 1. Is it Windows application?2. Is it 32 bit application or 64 bit?3. Which version of Delphi?4. How your Firedac connection params looks like? Regards,Karol Bieniaszewski #yiv0035744217 #yiv0035744217 -- #yiv0035744217ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0035744217 #yiv0035744217ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0035744217 #yiv0035744217ygrp-mkp #yiv0035744217hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0035744217 #yiv0035744217ygrp-mkp #yiv0035744217ads {margin-bottom:10px;}#yiv0035744217 #yiv0035744217ygrp-mkp .yiv0035744217ad {padding:0 0;}#yiv0035744217 #yiv0035744217ygrp-mkp .yiv0035744217ad p {margin:0;}#yiv0035744217 #yiv0035744217ygrp-mkp .yiv0035744217ad a {color:#ff;text-decoration:none;}#yiv0035744217 #yiv0035744217ygrp-sponsor #yiv0035744217ygrp-lc {font-family:Arial;}#yiv0035744217 #yiv0035744217ygrp-sponsor #yiv0035744217ygrp-lc #yiv0035744217hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0035744217 #yiv0035744217ygrp-sponsor #yiv0035744217ygrp-lc .yiv0035744217ad {margin-bottom:10px;padding:0 0;}#yiv0035744217 #yiv0035744217actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0035744217 #yiv0035744217activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0035744217 #yiv0035744217activity span {font-weight:700;}#yiv0035744217 #yiv0035744217activity span:first-child {text-transform:uppercase;}#yiv0035744217 #yiv0035744217activity span a {color:#5085b6;text-decoration:none;}#yiv0035744217 #yiv0035744217activity span span {color:#ff7900;}#yiv0035744217 #yiv0035744217activity span .yiv0035744217underline {text-decoration:underline;}#yiv0035744217 .yiv0035744217attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0035744217 .yiv0035744217attach div a {text-decoration:none;}#yiv0035744217 .yiv0035744217attach img {border:none;padding-right:5px;}#yiv0035744217 .yiv0035744217attach label {display:block;margin-bottom:5px;}#yiv0035744217 .yiv0035744217attach label a {text-decoration:none;}#yiv0035744217 blockquote {margin:0 0 0 4px;}#yiv0035744217 .yiv0035744217bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0035744217 .yiv0035744217bold a {text-decoration:none;}#yiv0035744217 dd.yiv0035744217last p a {font-family:Verdana;font-weight:700;}#yiv0035744217 dd.yiv0035744217last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0035744217 dd.yiv0035744217last p span.yiv0035744217yshortcuts {margin-right:0;}#yiv0035744217 div.yiv0035744217attach-table div div a {text-decoration:none;}#yiv0035744217 div.yiv0035744217attach-table {width:400px;}#yiv0035744217 div.yiv0035744217file-title a, #yiv0035744217 div.yiv0035744217file-title a:active, #yiv0035744217 div.yiv0035744217file-title a:hover, #yiv0035744217 div.yiv0035744217file-title a:visited {text-decoration:none;}#yiv0035744217 div.yiv0035744217photo-title a, #yiv0035744217 div.yiv0035744217photo-title a:active, #yiv0035744217 div.yiv0035744217photo-title a:hover, #yiv0035744217 div.yiv0035744217photo-title a:visited {text-decoration:none;}#yiv0035744217 div#yiv0035744
Re: [firebird-support] FB3 Embedded Firedac Error
On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br [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
Re: [firebird-support] FB3 Embedded Firedac Error
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. 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 m...@lawinegevaar.nl [firebird-support] escreveu: On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br [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 #yiv0610135399 #yiv0610135399 -- #yiv0610135399ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0610135399 #yiv0610135399ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0610135399 #yiv0610135399ygrp-mkp #yiv0610135399hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0610135399 #yiv0610135399ygrp-mkp #yiv0610135399ads {margin-bottom:10px;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad {padding:0 0;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad p {margin:0;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad a {color:#ff;text-decoration:none;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc {font-family:Arial;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc #yiv0610135399hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc .yiv0610135399ad {margin-bottom:10px;padding:0 0;}#yiv0610135399 #yiv0610135399actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0610135399 #yiv0610135399activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0610135399 #yiv0610135399activity span {font-weight:700;}#yiv0610135399 #yiv0610135399activity span:first-child {text-transform:uppercase;}#yiv0610135399 #yiv0610135399activity span a {color:#5085b6;text-decoration:none;}#yiv0610135399 #yiv0610135399activity span span {color:#ff7900;}#yiv0610135399 #yiv0610135399activity span .yiv0610135399underline {text-decoration:underline;}#yiv0610135399 .yiv0610135399attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0610135399 .yiv0610135399attach div a {text-decoration:none;}#yiv0610135399 .yiv0610135399attach img {border:none;padding-right:5px;}#yiv0610135399 .yiv0610135399attach label {display:block;margin-bottom:5px;}#yiv0610135399 .yiv0610135399attach label a {text-decoration:none;}#yiv0610135399 blockquote {margin:0 0 0 4px;}#yiv0610135399 .yiv0610135399bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0610135399 .yiv0610135399bold a {text-decoration:none;}#yiv0610135399 dd.yiv0610135399last p a {font-family:Verdana;font-weight:700;}#yiv0610135399 dd.yiv0610135399last p span {margin-right:10px;font-family:Verdana;fon
Re: [firebird-support] FB3 Embedded Firedac Error
See my replies below On Tue, Sep 3, 2019 at 1:13 PM Elton Fadel galdari...@yahoo.com.br [firebird-support] 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 > m...@lawinegevaar.nl [firebird-support] > escreveu: > > > > > On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br > [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 > > >
Re: [firebird-support] FB3 Embedded Firedac Error
>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.sug...@gmail.com [firebird-support] escreveu: See my replies below On Tue, Sep 3, 2019 at 1:13 PM Elton Fadel galdari...@yahoo.com.br [firebird-support] 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 m...@lawinegevaar.nl [firebird-support] escreveu: On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br [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 #yiv7328498315 #yiv7328498315 -- #yiv7328498315ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7328498315 #yiv7328498315ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7328498315 #yiv7328498315ygrp-mkp #yiv7328498315hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7328498315 #yiv7328498315ygrp-mkp #yiv7328498315ads {margin-bottom:10px;}#yiv7328498315 #yiv7328498315ygrp-mkp .yiv7328498315ad {padding:0 0;}#yiv7328498315 #yiv7328498315ygrp-mkp .yiv7328498315ad p {margin:0;}#yiv7328498315 #yiv7328498315ygrp-mkp .yiv7328498315ad a {color:#ff;text-decoration:none;}#yiv7328498315 #yiv7328498315ygrp-sponsor #yiv7328498315ygrp-lc {font-family:Arial;}#yiv7328498315 #yiv7328498315ygrp-sponsor #yiv7328498315ygrp-lc #yiv7328498315hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7328498315 #yiv7328498315ygrp-sponsor #yiv7328498315ygrp-lc .yiv7328498315ad {margin-bottom:10px;padding:0 0;}#yiv7328498315 #yiv7328498315actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7328498315 #yiv7328498315activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7328498315 #yiv7328498315activity span {font-weight:700;}#yiv7328498315 #yiv7328498315activity span:first-child {text-transform:uppercase;}#yiv7328498315 #yiv7328498315activity span a {color:#5085b6;text-decoration:none;}#yiv73284