Connection Problem

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
JoaoMarcos
Posts: 26
Joined: Fri 28 Jun 2013 20:26

Connection Problem

Post by JoaoMarcos » Tue 25 Oct 2016 15:47

ODAC latest version
Delphi 7

I have this situation:

My application can't connect to database Direct ou Client Mode.
In command prompt using TNSPING utility against the database it responds OK.
Even SQLPlus can connect to the database.
Trying to connect on Client Mode gives ORA-12170
Trying to connect on Direct Mode gives:
NET: Network error (Cannot connect to server on host 'SERVER':
Uma tentativa de conexão falhou porque o componente conectado não respondeu
corretamente após um período de tempo ou a conexão estabelecida falhou
porque o host conectado não respondeu.
Socket Error Code: 10060($274C))
<Host = SERVER:1521>


Is there something in TOraSession that can be made to identify this problem or avoid it? Here's my TORASESSION:

Code: Select all

object Oracle: TOraSession
    Options.Direct = True
    Server = 'SERVER:1521:SID'
    LoginPrompt = False
    AfterConnect = OracleAfterConnect
    Left = 280
    Top = 56
  end

JoaoMarcos
Posts: 26
Joined: Fri 28 Jun 2013 20:26

Re: Connection Problem

Post by JoaoMarcos » Thu 27 Oct 2016 12:57

We found a issue on the executable name renaming the file made the connection work. Seems that something is blocking network access by the exe name.

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

Re: Connection Problem

Post by MaximG » Fri 04 Nov 2016 08:44

We are glad you have localized the problem. Please contact us concerning ODAC usage.

Post Reply