Error 10061 when connecting to db

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
bromleyl

Error 10061 when connecting to db

Post by bromleyl » Mon 04 Apr 2005 17:10

I have been given a new Oracle database to connect to, when Net is false it works OK. If Net is true I get error 10061 when connecting the session component. I am using the IP address rather than server name, and the port and instance name match that in the tnsnames.ora.

I am using ODAC 4.15 and Delphi 7.

I realise that this is probably in the set-up at the server end as I have other succesful connections on the same intranet, but can someone explain why SQL.Net can connect to Port 1521 but I cannot using the direct IP method.

bromley

Found the problem

Post by bromley » Mon 04 Apr 2005 17:26

Please ignore the question, I found the problem.

The IP address was actually the address of the disk cluster not the server. Ping needed a fully qualified address (with domain name) to give me the correct address.

thanks anyway.

Post Reply