- Increase the Max Pool Size attribute of the ConnectionString property.
Syntax:
Data Source=urOracle;User Id=urUsername;Password=urPassword;Max Pool Size=50;Connection Timeout=60;
Sample Code of setting Max Pool Size to 1000 using IKBDbSupport to connect to Oracle database in C#:
string ldb = "ckb20171";
string lhoststring = "ckb20171";
string luserid = "ckb";
string lpwd = "ckb999";
string lPoolSize = "1000";
string lconnString = string.Format("Data Source ={0}; User Id = {1}; Password = {2}; Max Pool Size = {3}", lhoststring, luserid, lpwd, lPoolSize);
dbsupport = new IKBDbSupport("Category Knowledge Base",lconnString,ldb.ToUpper(),DbProviderType.Oracle,60);