11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
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
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
Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
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?
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?
Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
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.
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
Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
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 ?
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 ?
Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
I upgraded to 11.3.1 also had the same problem connected error message"NET: Invalid port: ."
Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
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
Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
I can confirm that this issue is fixed in the nightly build
Re: 11.3.1 - Connection failure using Direct Connection (Oracle with SCAN Listener)
We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning our product usage.