我在.net中使用此连接字符串连接到oracle并保持超时获取大的结果集.
如何使用此连接字符串设置更长的连接超时?
static private string GetOracleConnectionString() { return "User Id=USER;Password=pass;Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=14.12.7.20)(PORT=1139))" + "(CONNECT_DATA=(SID=QCTRP1)));"; }
return "User Id=USER;Password=pass;Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=14.12.7.20)(PORT=1139))" + "(CONNECT_DATA=(SID=QCTRP1)));Connection Timeout=60;";