Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Changed connection parameters in Tokyo 10.2.1?


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 6 - Last Post: Nov 5, 2017 2:31 AM Last Post By: Dmitry Arefiev Threads: [ Previous | Next ]
Marco A. A. San...

Posts: 22
Registered: 4/10/97
Changed connection parameters in Tokyo 10.2.1?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 9, 2017 10:32 PM
Hi, all,

In my development machine I've always used the Protocol=Local entry on Firedac to tell it to connect to my local Firebird instance. But starting in 10.2.1, this line gives me the message:

"[Firedac][Phys][FB]: Unable to complete network host "xnet". Failed to locate host machine".

Eliminating this line, but keeping the server name void, I can connect to my local instance. So has Firedac changed its connection options for Firebird, or maybe is it a bug?

Kind Regards,
Marco
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Changed connection parameters in Tokyo 10.2.1?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 15, 2017 1:40 AM   in response to: Marco A. A. San... in response to: Marco A. A. San...
This is a regression in Tokyo 10.2.1. The workarounds are:
* do not use Protocol=Local
* use fbclient.dll v 3.0

If needed I can provide a patch.

--
With best regards,
Dmitry
Marco A. A. San...

Posts: 22
Registered: 4/10/97
Re: Changed connection parameters in Tokyo 10.2.1?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 15, 2017 12:16 PM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev

If needed I can provide a patch.

--
With best regards,
Dmitry

Thanks, Dmitry! I already did the workaround excluding the line for local connections, as my clients are still on FB 2.5, No patch needed.

Kind Regards,
Marco
Jo Reiter

Posts: 10
Registered: 10/18/99
Re: Changed connection parameters in Tokyo 10.2.1?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 16, 2017 12:40 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Am 15.08.2017 um 10:40 schrieb Dmitry Arefiev:

If needed I can provide a patch.
I've found the same problem and would be interested in the patch.
Thanks!
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Changed connection parameters in Tokyo 10.2.1?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 16, 2017 1:49 AM   in response to: Jo Reiter in response to: Jo Reiter
The patch is posted:
https://forums.embarcadero.com/thread.jspa?threadID=254556

--
With best regards,
Dmitry
Brian Ford

Posts: 10
Registered: 7/25/10
Re: Changed connection parameters in Tokyo 10.2.1?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 2, 2017 12:00 PM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
I can't find the source files to apply your patch to. Are they included with the Professional Edition of Delphi.

I only have 3 source files in the C:\Program Files (x86)\Embarcadero\Studio\19.0\source\data\firedac folder.
They are: FireDac.Phys.pas, FireDac.Phys.SQLGenerator, and FireDac.Phys.SQLPreprocessor.

In one part of our app, I was able to workaround the issue by removing the Protocol=Local from my connection string; however in another section where we use TFDFBNBackup class to backup our database, we do not connect using a connection string; but rather by filling in the properties of that class, and I can't find a workaround for this case..

e.g.

Backup := TFDFBNBackup.Create(nil);
try
Backup.DriverLink := FDriverLink;
Backup.UserName := FUserName;
Backup.Password := FPassword;
Backup.Host := 'localhost';
Backup.Protocol := ipLocal;
Backup.Level := 0;

Backup.Database := GetDataBaseName;
Backup.BackupFile := GetBackupDatabaseName;

FBackupEvent.ResetEvent;
Backup.Backup;
except
end;


Dmitry Arefiev wrote:
The patch is posted:
https://forums.embarcadero.com/thread.jspa?threadID=254556

--
With best regards,
Dmitry
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Changed connection parameters in Tokyo 10.2.1?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 5, 2017 2:31 AM   in response to: Brian Ford in response to: Brian Ford
Are they included with the Professional Edition of Delphi.

Pro does not include RTL source codes.

I can't find a workaround for this case..

Do not use ipLocal.

--
With best regards,
Dmitry
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02