HI ALL,
I'm having trouble on Access to the oarcle database with odp.net. the connection strings is as follows:
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=filesynctest2)(PORT=1521))(CONNECT_DATA=(SID=filesync1)));User Id=xjliu;Password=111111; Max Pool Size=10; Min Pool Size=1;
My program and database are on different machines, and works ok.
but when network is disconnected, there are errors as follows:
ORA-12545: Connect failed because target host or object does not exist
Connection request timed out
Connection request timed out
Connection request timed out
...
when the network back to normal, the errors go on, and can‘t recovery itself, until i restart the program.
i use OracleConnection.ClearAllPools(), but it dose not work
can someboby help me?