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.
Error 10061 when connecting to db
Found the problem
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.
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.