11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Post by dados » Mon 31 Aug 2020 09:48

Hi,

Just upgraded from 11.2.5 to 11.3.1
When I put TOraSession on a form and enter my Oracle server details and connect I get this error message
"NET: Invalid port: ."
I'm connecting to a 12.1.0.2 RAC Instance using Service Name
The server is using SCAN listener and if I use scan listener name it fails but if I use direct instance name it works and connects

Similar to this older issue I had before:
viewtopic.php?f=5&t=33408&p=115454&hili ... er#p115454

And like before I cannot provide you with db access

I've tested on Delphi 10.2, 10.3, 10.4 and downgraded back to 11.2.5
Please fix

Also the uninstaller for version 10.3.1 for delphi 10.2, 10.3, 10.4 on Windows 10 is broken, might want to check that out as well

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Post by MaximG » Tue 01 Sep 2020 12:54

Please send us your СonnectionString without sensitive information, such as your username, password or server address, and the code snippet that initializes a connection to Oracle in your project.
We have successfully uninstalled ODAC 11.3.1. Please describe the issue with uninstalling ODAC. Are you using the same Windows user to install and delete ODAC? Are you getting any errors during the uninstall process?

dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Post by dados » Tue 01 Sep 2020 14:14

Code: Select all

unit Unit21;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, OraCall, Data.DB, DBAccess, Ora;

type
  TForm21 = class(TForm)
    OraSession1: TOraSession;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form21: TForm21;

implementation

{$R *.dfm}

procedure TForm21.FormCreate(Sender: TObject);
begin
  OraSession1.ConnectString := 'Direct=True;Host=XXX;Service Name=XXX;User ID=XXX;Password=XXX;Login Prompt=False';
  OraSession1.Connect;
end;

end.
This code works with 11.2.5 and older but fails with 11.3.1 - Could be a SCAN Listener issue because it works when using an one of the instance name but not when using scan listener name.


When uninstalling í get a dialog that says: "Windows cannot find 'C:\Program Files (x86)\Devart\ODAC for RAD Studio 10.3\Uninstall\unins000.exe'

For Delphi 10.2, 10.3 and 10.4 and it's repeatable

ODAC 11.2.5 installer/uninstaller works well as all the previous installers
It's really not a problem I just run 11.2.5 installer to downgrade
And yes I'm using the same user

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Post by MaximG » Wed 02 Sep 2020 12:22

We'll test connectivity to Oracle with SCAN Listener and let you know the result in the near future.
We haven't changed the behavior of our installers for a long time. Our users haven't report such an issue yet.
Could you try to install ODAC on another machine or virtual environment to test the connectivity ?

xadragon
Posts: 2
Joined: Sat 27 May 2017 02:15

Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Post by xadragon » Sat 05 Sep 2020 05:44

I upgraded to 11.3.1 also had the same problem connected error message"NET: Invalid port: ."

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Post by MaximG » Fri 09 Oct 2020 09:50

We've reproduced the issue and fixed it. The fix will be included in the next build of our product. As a workaround, we can send you a night ODAC build including the required changes. For this provide us with your license number and IDE version you are interested in For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Post by dados » Mon 12 Oct 2020 11:13

I can confirm that this issue is fixed in the nightly build

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)

Post by MaximG » Tue 13 Oct 2020 09:44

We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning our product usage.

Post Reply