Unable to connect to Oracle server on the first attempt.
681517Jul 8 2010 — edited Aug 18 2010Hi,
I've downloaded the Oracle Data Provider for .NET and I've installed it on my computer. Only this software, and only the client tools and there are no more Oracle products intalled on this computer.
I've developed a test application in order to take a look to these libraries but I am very dissapointed with the behaviour of the OracleConnection class, and that is because when I call the open() method for the first time it is impossible to open the connection, the application never returns from this call. If I close the application and I execute it again it takes 0.0 seconds to open the connection and If I wait about 5 or 10 minutes without querying the database, next time I try to connect it fails again showing the same behaviour that it showed in the first connection attempt.
I really don't know if I am missing some software installation or any configuration, I've tried this on two computers and the result is the same. I've looked for an answer in this forum but the only I have fount takes not sense, it says that it deppends of the user used to connect to the database.
I have to add that the database is not in the same network of the computer.
Thanks in advance,Regards.
Edited by: user7134478 on 08-jul-2010 9:50