Direct connect using service name fails

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

Direct connect using service name fails

Post by dados » Tue 22 Mar 2016 14:59

I'm trying to connect to a server that is RAC with 2xinstances in direct mode and I'm getting this error:
NET: Network error (Cannot change host for the active connection) <Host = xxxxxx.xxxx.xx:1521>
It fails when using the alias to the scan listener, but works when using one of the instances as host.

I've basicly tried a version of my program that uses an older version of ODAC (9.5.18) and that works so from that version to the current (9.6.22) something broke. I have also another program that uses ODAC (9.6.20) and that works as well.

These are my more detailed test results:
ODAC (9.6.22) OCI from inside network works
ODAC (9.6.22) OCI over VPN works
ODAC (9.6.22) Direct from inside network works
ODAC (9.6.22) Direct over VPN fails
SQLDeveloper from inside network basic works
SQLDeveloper over VPN basic works
SQLDeveloper from inside network advanced jdbc works
SQLDeveloper over VPN advanced jdbc works

So I think that this proves that it's not the VPN connection that causes this error.

-Update
I'm using Seattle
I downgraded to 9.6.21 with the same result.
Then I downgraded to 9.6.20 and that version works.

- Arni Thor

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Direct connect using service name fails

Post by AlexP » Thu 24 Mar 2016 07:57

Hello,

We can't reproduce the issue on our test servers. If you can give us access to your server, we will test this behavior directly on it.

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

Re: Direct connect using service name fails

Post by dados » Thu 24 Mar 2016 14:48

I'm afraid I can't do that.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Direct connect using service name fails

Post by AlexP » Fri 25 Mar 2016 13:29

Unfortunately, we can't check our driver on the described configuration. We need just access to Connect to your server (SELECT/INSERT, etc. are not required).

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

Re: Direct connect using service name fails

Post by dados » Thu 31 Mar 2016 14:11

Fixed with a patch, thanks AlexP.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Direct connect using service name fails

Post by AlexP » Fri 01 Apr 2016 04:59

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.

Post Reply